
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 22, 2022 09:17 AM
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
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 22, 2022 10:20 PM
Hmm, if I’m understanding you correctly, you could:
- Sync the
Orders
tabe fromOperations
base into thePurchases
base - Create an automation in
Purchases
where, every time a new record gets created in theOrders
synced table, it’ll link said newOrders
record to theSuppliers
record inPurchases
Should work I think

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Nov 23, 2022 12:15 AM
Thank you for your advise Adam.
I’m going to try it out and let you know.
Have a great day
