For the first time I am being asked to develop an Access 2000 database that currently contains no data.

I was wondering if there is a design advantage to using a table as 1)a look-up source versus 2)a related table.

Barbarian

The options aren't mutually exclusive. Look-up tables typically stand in a 1:M relationship to the table that stores values from the look-up table, and referential integrity is typically established between the two, though it needn't be if data validation is controlled by some other means, e.g. through the UI). I generally establish referential integrity via the Relationships window for look-up tables.

Bob