How can I pull multiple records from one table and add in another table?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered
How do I pull multiple different records from one table into another?  I have an "order" table which needs to pull from the "customer" table to choose billing, pickup and delivery locations.  The "customer" can depending on the order be used for billing, pickup or delivery location.  Please advise.


Photo of Andre

Andre

  • 0 Points

Posted 3 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 62,316 Points 50k badge 2x thumb
Nice picture. Bayou missed your calling as an artist.

No problem.

Just make your first relationship where 1 Customer has many orders. The app will generate a field called Related Customer.  Rename is after you create the relationship to be called Related BIlling Customer.

Then just start over with a new Relationship and repeat.

Then repeat again.