Skip to main content
Question

2 picklists affect each other.

  • January 17, 2022
  • 0 replies
  • 57 views
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
------------------------------
This topic has been closed for replies.

  • JohnNiumata
  • Author
  • Registered
  • January 17, 2022
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
------------------------------
Terms & ConditionsAccessibility statement