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
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
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
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.
Lookup fields will always automatically update when the master record changes.