Look up previous information.

  • Thread starter Thread starter Tay J.
  • Start date Start date
T

Tay J.

is there an easy way when entering information in a database for Access to
look and see if the information is already in yoru database? I am using
Access 2003

Thanks!!
 
what do you mean

are you trying to get a value from another table and put it into that
one or are you wanting to make sure information is unique

if you want the first option then use a lookup table

if you want the second option open the table in design view and select
the field you want to be unique and then down the bottom of the window
change the property

Indexed

from no or yes (duplicates OK) to

Yes (No Duplicates)

and that will make that field unique

that is a dirty simple method if you want to make a composit unique
key when the unique value is accross several values it gets a bit
harder

open the table in design view like before

this time up the top you will see a button next to the key that looks
liek a lightning bolt

that button is called indexes

when you click it you will get a table

index name fieldname sortorder

you will have your primary key there


index name fieldname sortorder
ID ID accending
primarykey ID accending

you need to add the fields you want


index name fieldname sortorder
ID ID accending
primarykey ID accending
compositunq field1 accending
field2 accending
field3 accending

and then click on the first one where is says compoditunq and you will
see properties appear at the bottom of the window

primary no
unique no
ingore nulls no

make it

primary no
unique yes
ingore nulls no


Hope the helps

Regards
Kelvan
 
I really do appreciate all of the help. I did try the combo box and it did
work but only brought up whatever field the combo box what attached to. Am I
missing something as I want to have it fill all of my fields from the name
address etc.

Thanks again!!
 
Let me add an additional question. If I were to look up using a query to see
if I have previously been to an address, if so can I have the system ask me
if I want to add a new entry or if the address is not found have it ask if I
would liek ot add a new record. Additionally I am redesigning this database
in Access 2007 then saving in 2003 so I cna use it at work on my XP laptop.
 
Back
Top