Creating a Dynamic Lookup which reflects on GridLine Item Section

Summary:

Content (required):

we created a costing sheet(GridLine item), which contains a discount type, and discount percent as fields. These fields are dynamic, meaning they can change for every line in every costing sheet (GridLine item).

The user defines the Discount Type in the Costing Sheet (GridLine item), and the Percentage should be read automatically from a lookup.

The main issue is that the Lookup containing the Type and Percent has to be dynamic since it changes for each Costing Sheet (GridLine item).

We need to define the Discount Type and Percent in a separate section (Table) where the user defines the different Discount Types and Percentages and it reflects automatically to the costing Sheet (GridLine item) based on the Discount Type already defined in the Costing Sheet (GridLine item).