In one base I have three tables. One is for Manufacturers and another is for Products. Manufacturers records have a field that can link to multiple products from the Products table.
A third table is for special offers. The data is imported here from a separate list and it includes linked fields for both the Manufacturer and the Product.
When a record is added here it will add the Manufacturer and Product to their respective tables, if they don’t already exist. But it doesn’t automatically link the Product to the Manufacturer.
Is there any way to make that happen?!