Create a sub table from a master table.

  • 0
  • 1
  • Question
  • Updated 1 year ago
  • Answered
Create a sub table from a master table. I have a master table into which I feed data from an excel every week. I want to create a sub table which takes in some fields and corresponding data from the master table and also has some extra fields which the user has to input. Whenever the master table is updated with new records or existing records also get updated in the master table, I want the sub table records to also get updated. However the user input field should remain the same for the sub table and the user can update if and whenever they want
Photo of Ankur Sanghai

Ankur Sanghai

  • 100 Points 100 badge 2x thumb

Posted 1 year ago

  • 0
  • 1
Photo of Matthew Neil

Matthew Neil

  • 31,438 Points 20k badge 2x thumb
What you will want is to create a relationship between the 2 tables. 

Any information you want in the details table from the master table can be added via a "lookup" field.

This information will just reference the master table data, and not interfere with the details table data that is entered by the user.
Photo of Ankur Sanghai

Ankur Sanghai

  • 100 Points 100 badge 2x thumb
Thanks for your reply.

I have a field in master table called "Stages"
My master table has 57 fields or headers as you may call it.

So I want a sub table with all the records in the master table which have "Stages" as 'Stage 7'
However in the sub table I only want 30 fields corresponding to those records which have Stage 7.

The sub table needs to be a live table which gets automatically updated whenever the master table is updated.

Thanks
Photo of Matthew Neil

Matthew Neil

  • 31,398 Points 20k badge 2x thumb
You will want to add those 30 fields to the relationship as a lookup field to the sub-table.

Lookup fields will always automatically update when the master record changes.