Hi there 🙂 Im have what is seems to me fairly complicated automation which I did not manage to complete, and would appreciate your suggestions.
I have three tables, all linking to each other; Database, Price, and Partners. Database table can be linked to multiple Price and Partners records, but Price and Partner can be linked to only one Database record.
I want to create an automation that duplicates all records from Price table linking to Database table, and then link the duplicated records to Partners table. The result will be having Database and Partners table linking to identical, but not the same records in Price table. The automation trigger is single select field in Partners table, set to Create.