Autofill of fields by relations | Voters

Autofill of fields by relations

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,

November 14, 2024

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?

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.

Photo Viewer