Forum Discussion

JohnNiumata's avatar
JohnNiumata
Qrew Trainee
3 years ago

2 picklists affect each other.

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

------------------------------
Johnny
------------------------------
Relationships
  • JohnNiumata's avatar
    JohnNiumata
    Qrew Trainee
    3 years ago
    update...
    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)


    ------------------------------
    Johnny
    ------------------------------
    • JohnNiumata's avatar
      JohnNiumata
      Qrew Trainee
      3 years ago
      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.

      ------------------------------
      Johnny
      ------------------------------