I have a scenario with a many-to-many relationship and trying to achieve an outcome where a new record is created on a separate table any time a linked record from Table 1 is updated.
For example, Product #1 is assigned to Purchase Order A and Purcha...
Thank you for the response! Was able to achieve this, however there was a subsequent issue where more than 2 records on Table 1 are being grouped on the second table by Purchase Order A, B, etc…
For example:
Product 1, Purchase Orders A & B
Product 2...
