Autofill of fields by relations
V
Volker Koelsche
I have created a solution to fill a process document.
The following fields must be filled
- Part before
- Resin before
and
- Part after
- Resin after
Since there is a fixed relation between part and resin, I would like to connect the part with the resin for typing in.
I have a single select field for the part and the same for the resin.
I'd like to choose only the part, and get, either an auto-fill for the resin or a fltered list of resins.
The idea is, to prevent choosing the wrong material for the parts.
I tried to find something in the list below or a tutorial, but without success.
Thanks, and kind regards,
Jon Darbyshire
Great to hear your perspective, Volker Koelsche! I have a few more questions for you:
- What specific criteria or rules define the fixed relation between parts and resins?
- Are there any exceptions or special cases where the auto-fill or filtered list should not apply?
- How frequently do the relations between parts and resins change, if at all?
V
Volker Koelsche
Hello Jon Darbyshire,
Thanks for your feedback.
1. The resin for each part is choosen and defined by the customer,
based on the area of application.
2. There are no special cases or exceptions.
3. The relationship between part and resin is fixed. However, an
alternative resin may need to be added in some cases.
Ideally, a relational table should connect the part with its resin, color, and other characteristics. This table should be valid across the entire solution. If not, the user would need to manually copy the relevant data into the table where it is required. (please see picture attached)
Part Resin Colour Customer
Cap 00001 PP red Milller
Fliptop 00011 HDPE yellow Smith
Screw cap 00013 LDPE green XYZ
Cap 00002 PP blue O´Brian
When a part is selected from a single-select field, the corresponding fields (Resin, Color, and Customer) should automatically populate if the data is available in the table. Alternatively, the single-select field should be filtered to show only the relevant options for resin, color, and customer.
Thanks, and kind regards.