Skip to main content
Question

Create a record in different table every time a specific field value is unique?

  • September 11, 2018
  • 0 replies
  • 49 views

I have an Orders table and a Ordered Items table. I would like for every time a new item record is added, if the due date doesn't match any other records' due dates, then a new record needs to be created in a Shipments table.

In essence, if all items are due on the same date, they should all be on the same shipment. If there are multiple dates, shipments should only be created for the unique dates.  

Can this be done in QB?

Thanks for any help!
This topic has been closed for replies.

  • Registered
  • September 11, 2018

Have you experimented with using Quick Base Actions?