Using a Multi Select Field on the Parent Record of a Relationship

  • 0
  • 1
  • Question
  • Updated 3 months ago
  • In Progress
I have a contact parent record with the Multi Select field: "Group"

  • Each Contact may have multiple groups.
  • Each Group has Unique Products

Can I set a relationship so that when I pick two or more groups, the product drop down will show only the products for the selected groups?

Note: No issue with One Group > Product Relationship. The moment we try to do multi select, it breaks.
Photo of JessicaD_QB

JessicaD_QB

  • 60 Points

Posted 3 months ago

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

QuickBaseCoach App Dev./Training, Champion

  • 51,306 Points 50k badge 2x thumb
There is a technique which would allow you to launch off a Contact (or say an order which has the contact selected), and it would present a list of qualifying products for that contact.  Then you would click a button to add the product to the order and continue clicking until all the products have been added.  the  you would click a link to return to the order where you would see that the line items have been created edit the line items for qty and price. 

But the steps to do that, while native, are a bit too complicated to put on this forum step by step.  it usually takes me about 1.5 hours to set this up for a client.  Contact me at QuickBaseCoach.com if you are interested in taking this off line.