Skip to main content
Question

Connected tables: Is it possible to set up a connection with 20 tables channeling data into one connected table?

  • May 18, 2018
  • 0 replies
  • 161 views
Hello,

I am working with a document library.

There are 20 tables, and different users have permission to access different tables. All records have file attachments.

I would like to set up a connected table so that all records from the 20 tables sync into one large table. Is that possible? (A table-to-table import wouldn't be able to import the file attachments so the connected table seems like the best option.)

The end goal would then be to create a report that searched the file attachment field using "contains the value <ask the user>" filter.

Any advice?

Thank you.
    This topic has been closed for replies.

    A sync table can only have 1 source.  But you could have 20 Actions on 20 tables to create a record in the centralized table.  The centralized table can have a formula to link back to the original document such that wen clicked, it will display the file attachment even though the file attachment is not actually on the centralized table.
    With this being the topic. I'm having some trouble. I am working on taking two tables and combining them into one. Is there an easier way of doing this without having to connect relationships and creating a new table?
    Terms & ConditionsAccessibility statement