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

Topic Labels: Sync
703 2
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

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

2 Replies 2

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

4 - Data Explorer
4 - Data Explorer

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