Hello,
in the "Products" entity, for each product I have the "Name" and "Product_ID" fields filled in. Example
Name: Paint White, Product_ID: Paint_001
Name: Paint Black, Product_ID: Paint_002
In the "Cases" entities, I want to create 2 fields there - "Complaint Product Name"(mapred to "Name" in "Products" Entity) and "Complaint Product ID"( mapred to "Product_ID" in "Products" Entity)
How to do if someone selects "Complaint Product Name" the system will automatically fill in "Complaint Product ID". And vice versa - if someone chooses "Complaint Product ID", it will automatically fill in "Name of the complained product"
Example:
If I select "Paint White" in the "Complainted Product Name" field, the "Complaint Product ID" automatically becomes "Paint_001"
and vice versa
If I select "Paint_002" in the "Complaint Product ID" field, the "Complaint Product Name" field will automatically become "Paint Black"
If you like, you can send me a post about this topic or a video that shows exactly this. thank you in advance