John Vinson wrote:
You can set the Default property of a control in a Form (the form you
should be using to enter data into your table) to a DLookUp()
expression retrieving a value from a table, but you can't do it in
the
table properties.

A front end application should not relied upon in place of constraints
in the database layer to maintain data integrity. A CHECK constraint to
reference other tables could be included in the table definition.

Jamie.

--