How do add multiple selections to a related field?

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • In Progress
I am looking for a way to add multiple selections relating to a specific field. Our company sells equipment for sports and through the website our customers make their purchases. Now, because the way the site is setup the website distributes payouts/releases funds to our bank weekly. As a result, one payout may be reflecting multiple purchases orders. That's why I was hoping to relate multiple purchase orders to a single payout. I've tried, but I can only seem to link one purchase order to one payout. Any help?
Photo of Ryan

Ryan

  • 940 Points 500 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,346 Points 50k badge 2x thumb
You said that 1 Payout has many Purchase Orders.


Is it also true that 1 Purchase Order can be paid out on multiple payouts?
Photo of Ryan

Ryan

  • 940 Points 500 badge 2x thumb
No--the purchase order will always be distributed on one purchase order 
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,346 Points 50k badge 2x thumb
Do you have a relationship set up where 1 Payout has Multiple Purchase Orders?  maybe you set up the Relationships backwards.
Photo of Ryan

Ryan

  • 940 Points 500 badge 2x thumb
it is backwards from what it looks like
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,346 Points 50k badge 2x thumb
So you are saying that you intend to kill that Relationship and reverse it?
Photo of Ryan

Ryan

  • 940 Points 500 badge 2x thumb
I guess so?