Get data from a linked record back to the original sync table

Hello,
I’m going to try to simplify my issue as much as possible. Hopefully it will be clear enough.

I have 2 bases : Operations & Purchases.
In Opérations I have a table with all my Orders.
In Purchases I have a table with all my Suppliers.

The Suppliers table is sync to the Operation base, and then my Orders’s records are link to the Suppliers still in my Operation base.
When I create a new Order I add the related Suppliers.
So on my Suppliers table in the Operation base I have for each supplier the listing of all the related orders as linked records.

Now I would like to have this same listing back in the Suppliers table, but in the Purchases base. And not as text field, but as linked records as well.

Is it possible ?

Thank you in advance

Hmm, if I’m understanding you correctly, you could:

  1. Sync the Orders tabe from Operations base into the Purchases base
  2. Create an automation in Purchases where, every time a new record gets created in the Orders synced table, it’ll link said new Orders record to the Suppliers record in Purchases

Should work I think

Thank you for your advise Adam.
I’m going to try it out and let you know.
Have a great day

1 Like