Need to enter two companies in one job. can choose them entering new job, upon saving only reflects second choice.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Need to be able to enter 2 companies per Job or per Activity. Have both lookup fields linked to Companies, and can choose two different companies when entering a new Job, yet upon saving it only reflects the second company chosen.

Photo of Laura

Laura

  • 10 Points

Posted 3 years ago

  • 0
  • 1
You will need to make a second relationship.  For example your field names would be 

[Related Company 1] and the lookup field [Company 1]

[Related Company 2] and the lookup field [Company 2]
Photo of Laura

Laura

  • 10 Points
Meaning make a second table to table relationship?
Yes, make a brand new Relationship similar to the first one.
Photo of Laura

Laura

  • 10 Points
Got it working, thank you so much and thank  you for being there on a weekend
I fear it's actually addiction.
Photo of Laura

Laura

  • 10 Points
There could always be worse ones than this