Retrieve data for Primary Key

[Neel]

I have a table that has a single column as the primary
key. The table is pre-populated with data as a result of
an Import. However, one of the foreign keys on the table
needs to be populated using a form.

I created a simple form using the table. I changed the
Primary key to be a Combo Box to display the values of the
primary key for the user to select. However, on selecting
a key value, the corresponding data on the form does not
change to that of the newly selected primary key.

Please help.

 

[Armen Stein]

I have a table that has a single column as the primary
key. The table is pre-populated with data as a result of
an Import. However, one of the foreign keys on the table
needs to be populated using a form.

I created a simple form using the table. I changed the
Primary key to be a Combo Box to display the values of the
primary key for the user to select. However, on selecting
a key value, the corresponding data on the form does not
change to that of the newly selected primary key.

Please help.

Hi Neel,

The combobox should be bound to the foreign key in your table, not the
primary key in the other "lookup" table.