Hi all,

I created one table named 'Fields' expressly for the purpose of
housing commonly used values for drop-downs in my main table called
'Main'.

One of the fields in 'Fields' is a list of last names.
i.e. that way the dropdown in Main contains last names i.e. Smith,
Jones, Taylor.

The problem I'm having is this:

When I select from the dropdown in one record in Main, it changes the
entries for all the records in Main.

In form view in Main, I selected Smith from the dropdown in record #1.

When I create a new record #2, 'Smith' is prepopulated in the field,
though I can change it to 'Jones.'  When I save my data and go back to
look at record #1, Jones has taken Smith's place.

The General Tab for this field reads:
Field Size:  50
Required:  Yes
Allow Zero Length:  No
Indexed:  Yes (Duplicates OK)
Unicode Compression:  Yes
(all other fields blank)

The Lookup Tab for this field reads:
Display Control:  List Box
Row Source/Type:  Table/Query
Row Source:  SELECT [Fields].[Last] FROM Fields;
Bound Column:  1
Column Count:  1
Column Heads:  No
(all other fields blank)

Someone please tell me what I'm doing wrong :(

Thanks,
Pat