Newbie Access 2000 Question

[califantasy]

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

 

[John W. Vinson]

Someone please tell me what I'm doing wrong

For one thing, using Lookup Fields. For another, using Table
Datasheets for editing. For a third, overnormalizing - having a table
of common last names is (especially in these multicultural days) an
exercise in futility!

You're making your life harder than it needs to be. Names are just
data; just use a textbox bound to your LastName field, and another
textbox bound to your FirstName field, and type in "Jones" "Tom" or
"Hafez" "Abdullah" or whatever you need.

John W. Vinson [MVP]