Debris wrote:
Hope I'm using my database design terms correctly, and that this make sense.

In a secondary table, I'm using the Lookup Wizard to look up a values in a
primary table. In the primary table, there is only one field

In the SQL standards and in the SQL literature, the 'primary' table is
called the referenced table and the 'secondary' table is the
referencing table; these can be considered the definitive terms. More
controversial is 'field': the literature and the purists will use
'columns' and 'rows' but the terms 'fields' and 'records' are so widely
used that they should be considered synonyms.

Jamie.

--