Creating Customer Fields in a Table and Displaying them in a Layout
The attached JPG shows the relationship of my project which works fine for one Operator (customer). After adding new operators in the Green table, I need to be able to add a field for each new customer in the blue tables to hold customer information relating to the 400 records in the Grey table. I know this kind of an apples to oranges relationship in trying to relate fields to records between tables but the records in the grey Protocol table has a large amount of information (elements) that needs to be related to each customers operation in the blue tables.
To make all the records match up I envision having fields (i.e., Op1, Op2 etc.) for a given number that each operator is assigned to contain the require information relating to the Protocol table. When a customers name is selected, the assigned fields are displayed in the layout.
I just can't get a better picture of what I want to accomplish, any help would be appreciated.