AnsweredAssumed Answered

Drop Down Box Issues

Question asked by Rodcha on Dec 11, 2008
Latest reply on Dec 12, 2008 by Jens Teich

Title

Drop Down Box Issues

Post

 

Function: I created a drop down box in my Client_Contacts Layout that displays a list of all names in a Client Table.

 

Problem: When I select the drop down field, a list of clients appear.  However, once I select a client, that client name appears in all records in my Client_Contact table.  Why is this happening?

 

Can anyone help me on this issue?

 

Present data structure:

 

Client Table                   Client_Contacts

Client ID_PK------------>Client_FK
Client_Name                  Client_Contacts_Company

                                   Client_Contacts_PK

 

I created a value list by using the values from Client_Names

The radio button: Include all values is selected.

 

Client_Contacts_Company is a Text field and not a Global field.

 

 

Outcomes