It's described here:
I get the impression that a lookup field and a validation table are the same thing?
I just want to make sure that I'm not doing that if it's bad to do that...
In the database I'm currently working on, I have a main table that holds some ID's of other stuff in other tables. Best way I can describe it is:
So the tables are linked that way, the ID is held in the main table, and the id corresponds to a person's favorite car. You just enter people's favorite cars in the tblCars and then they link back to the main table thru the ID.
Is that a Lookup field?
Thanks!!
Matt
I get the impression that a lookup field and a validation table are the same thing?
I just want to make sure that I'm not doing that if it's bad to do that...
In the database I'm currently working on, I have a main table that holds some ID's of other stuff in other tables. Best way I can describe it is:
Code:
tblMain tblCars
-------- -------
AutonumberID |--FavCarID
Last Name | FavCarType
First Name |
FavCarID------
etc...
So the tables are linked that way, the ID is held in the main table, and the id corresponds to a person's favorite car. You just enter people's favorite cars in the tblCars and then they link back to the main table thru the ID.
Is that a Lookup field?
Thanks!!
Matt