View Only
  • 1.  2 picklists affect each other.

    Posted 01-17-2022 11:18
    I'm a little rusty as it's been a few months since I changed anything. I'm struggling with this issue.

    I have a "job" form with a pick list of contact names from the customer "contacts table"

    I want to have 2 pick lists on the form, one is to pick the customer's project manager, the other is to pick the billing contact.

    my problem is that when I change one of the selections, the other details from the other picklist is changed.

    how can I have 2 of these? what am I doing wrong?

    screenshot attached of form & relationship diagram


  • 2.  RE: 2 picklists affect each other.

    Posted 01-17-2022 12:00
    I  have added the 2 fields i need to the "jobs" table 
    1. billing contact
    2. billing email

    I have added a new relationship which automatically got named "related contact3"
    screenshot attached.

    then I added those fields to the form. screenshot att.

    but the 2 drop downs are still synced. (change 1, then the other also changes to that value)


  • 3.  RE: 2 picklists affect each other.

    Posted 01-17-2022 12:41
      |   view attached
    Daryl at quickbase support gave me the solution.

    I had picked the wrong item in the form...
    i picked "billing contact" which is the field in the table, however I should have chosen a newly added field which includes the relationship.
    see screenshot.