I have synced our main Inventory base (shared by all staff) to our Billing base (limited access to staff). I’d like to be able to create a lookup field within Inventory that shows attachments I added in Billing.
Alternatively, if I could just restrict user permissions/hide a table in the Inventory base, I wouldn’t need to sync between two bases and could merge into one.
You may create separate table in Billing for output, link it to main table, reflect attachments there via lookup, and then sync it back to another table of Inventory. sometimes, even more than 2 syncs are needed between 2 bases, including multi-source (from different tables, with field mapping) and multi-destination (when one of your bases receive 3rd party data by API, and that data needs to be shared to other bases).
Of course, it depends on plan limit.