We want to create a 4 level grid to display the following information
Level1: Projects – every project number is unique
Level 2: The orders that belong to the project – The orders for every project starts with order no 0001. There could be many orders with the same number (e.g. 0001) but only one order 0001 for each project. Project plus order number is unique
Level3: The Line Items within an order. Again a line item 0001 will appear in every order. Project + Order No + line Item is unique
Level4: The Release Note numbers for each Line Item. There could be many Release not numbers for each Project, Order No, Line Item Combination.
Question:
How should the Master and detail keys be structured for each level.
Level1: Projects – every project number is unique
Level 2: The orders that belong to the project – The orders for every project starts with order no 0001. There could be many orders with the same number (e.g. 0001) but only one order 0001 for each project. Project plus order number is unique
Level3: The Line Items within an order. Again a line item 0001 will appear in every order. Project + Order No + line Item is unique
Level4: The Release Note numbers for each Line Item. There could be many Release not numbers for each Project, Order No, Line Item Combination.
Question:
How should the Master and detail keys be structured for each level.