Forum Discussion

AnkurSanghai's avatar
AnkurSanghai
Qrew Member
8 years ago

Create a sub table from a master table.

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
App builders
  • MCFNeil's avatar
    MCFNeil
    Qrew Captain
    8 years ago
    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.
  • AnkurSanghai's avatar
    AnkurSanghai
    Qrew Member
    8 years ago
    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
    • MCFNeil's avatar
      MCFNeil
      Qrew Captain
      8 years ago
      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.