Skip to main content

Aggregating records tagged with a category

  • June 12, 2018
  • 1 reply
  • 11 views
K

Hey everyone,

In my base I’ve got about 12 different tables. In each of those tables I have a “Brand” column that is “multiple select” and every table has the same 15 different “Brands” to select from. So every record in every table is tagged with one or multiple brands.

I want to create a table in that same base that aggregates all records from all tables and sorts them by “Brand”. I assume this could be done through some sort of linking method, but so far I’ve been unsuccessful. Any suggestions out there?

Thanks in advance!

    This topic has been closed for replies.

    1 reply

    E
    Forum|alt.badge.img+17

    Yes, with the Brands as a Table you will get several benefits:

    • The list of brands will be consistent across you entire database
    • You will have Linked Records from every other Table in the Brands table.
    • You will be able to Filter brands based on that linked information

    You just have to convert the MultiSelect field into a Linked Record field type.

      Terms & ConditionsAccessibility statement