Yes, I have figured out how to add the record automatically in the shipments table, But I need to be able to add the record ONLY when the "ordered item" record's "due date" field is a date that another "ordered item" record doesn't currently have.
For example,
Item #1 due date = "10/10/2020"
Item #2 due date = "10/10/2020"
Item #3 due date = "11/12/2020"
Item #4 due date = "12/15/2020"
There should only be 3 shipment records auto-generated to match the due dates that are unique, because Lines 1 & 2 are the same due date and can be shipped together as one shipment.
Any way to check for unique dates before auto-generating a record in the shipments table with the corresponding due date?
Thanks
