Relating invoice to multiple workorders

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered
Hi, I have relationship between invoice table and workorders table (see attached). When I select and create invoice,  i want to be able to attach multiple work orders to it. right now I am only able to click and attach one at a time. How to change the relationship, or is there a trick how I can change the design that it would allow me to select and attach many work orders to 1 invoice.  

thank you

Photo of Indre

Indre

  • 0 Points

Posted 4 years ago

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

QuickBaseCoach App Dev./Training, Champion

  • 65,542 Points 50k badge 2x thumb
Is your work flow such that you create a bunch of workorders and then from time to time you want to gather up a bunch of them as children associated with 1 parent invoice?  if so, then you would run a list of Work orders which are not on an invoice (ie [Related Invoice] is blank), and then use Grid edit on that report to mass update to select an invoice.  You could also make a conditional drop down on the field for [related invoice] such that the only options available are invoices for the same [Related Customer], thus limiting the drop down to relevant Invoices.  You could also use a form to drive the grid edit drop down choices to filter only "Open invoices" if there is a such a concept.  that would make he drop own listy really short - like 1 invoice.
Photo of Indre

Indre

  • 0 Points
thank you for advice, I will try.