john bimson redating the exodus - Updating edgar access codes
If the query for the lookup list is based on another query, you must open that second query, find the source table and field from which the second query takes its data, and change the values in that table.
If you have another form that you would prefer to use for this purpose, you can enter the name of the form in the List Items Edit Form property, as follows: The items in a value list reside in the same table as the other values in a record.
By contrast, the data in a lookup field resides in one or more other tables.
Validation rules can be set in either table design or table datasheet view.
There are three types of validation rules in Access: By default, Access displays list data in a combo box control, although you can specify a list box control.
In turn, those design principles affect how you enter data.