Unanswered: Can you help me understand lookup table?
I have 2 tables in a one to many relationship - table 2 is a lookup table:
barrier_type (record can only have one type of barrier)
Description (this field lists 15 possible barriers)
Acronym (acronyms for barriers)
First of all, what exactly is a "lookup table"? What is its purpose?
Could you give me an example of how it would or could be included in a queries. What is table 3's function? All it seems to do to me is merely list possible barrier types...why does it need to relate to table 1
In it's simplest if you create a lookup field in table 1 on barrier_typeID, then table 2 will become a lookup table. The wizard will create the relationships and you are done.
To manually create it, you would create a one to many relationship from table 2 barrier_typeID to table1 barrier_typeID. On your input form you could use the combobox wizard to lookup the values in a table, in your case table2.