Skip to main content
Question

Create a sub table from a master table.

  • October 11, 2017
  • 0 replies
  • 72 views
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
    This topic has been closed for replies.

    • MCFNeil
    • Registered
    • October 11, 2017
    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
    • Author
    • Registered
    • October 11, 2017
    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
    Terms & ConditionsAccessibility statement