Automation to add one record to another table when something is triggered in another table

  • 0
  • 1
  • Question
  • Updated 3 months ago
I have three tables: Purchase Orders, Cost Sheets, and Entries. The relationship is such that a Purchase Order can have multiple entries and Cost Sheets can have multiple entries. I have an "Approval" button on the Cost Sheets table, when triggered, automatically approves all entries associated with that cost sheet.
On the entries table, users are required to select a Vendor for each entry. Each entry is associated with a Cost Sheet, such that one cost sheet may have anywhere from 1 to infinite number of entries that may also belong to 1 to infinite number of vendors. 
The challenge I am having is how to automatically generate a purchase order for each unique vendor when a cost sheet (and entries) are approved. Currently, the automation fails since the related vendor field is required to be unique, and once I remove that requirement, the automation runs but creates multiple purchase orders for the same vendor.
Photo of Niraj Shah

Niraj Shah

  • 240 Points 100 badge 2x thumb

Posted 3 months ago

  • 0
  • 1

Be the first to post a reply!