1 Reply Latest reply on Dec 12, 2008 4:07 AM by Jens Teich

    Drop Down Box Issues

    Rodcha

      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.

       

       

        • 1. Re: Drop Down Box Issues
          Jens Teich
             You will have a lot less trouble when you create new contacts from a portal on a layout based on the clients table.

          Probably you already have a portal on a client layout showing all related contacts. Allow the relationship of this portal to create new records in contacts and everything will be ok.

          Jens