2 Replies Latest reply on Jun 22, 2013 10:40 AM by PhillipFountain

    Creating Customer Fields in a Table and Displaying them in a Layout

    PhillipFountain

      Title

      Creating Customer Fields in a Table and Displaying them in a Layout

      Post

           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.

      Relation.jpg