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 m...
Forum Discussion
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.
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.