Hi,
I have 3 fields (Department, Rate, In-charge), and I need "Rate" and "In-charge" to auto reflect the result once "Department" is chosen.
From the below database design, for example, when user select
Eg1. departA > rate will show "rate1" > incharge will show peter
Eg2. departB > rate will show "rate2" > incharge will show peter
Can someone kindly advise how can I achieve the above? Thanks.
Below is my database design:
Table: department
Field:
**name, inchargeid, rateid**
departA, 1, 1
departB, 1, 2
-------------------------
Table: rate
**name, rateid**
rate1, 1
rate2, 2
---------------------------
Table: incharge
**name, inchargeid**
peter, 1
mary, 2
I have tried using "This dropdown is dependent on ..." in Editor tab, however the link field can only be set to one field.
Table(department), Link field (inchargeid)
Table (incharge), category control (department), category field (inchargeid)
Table (rate), category control (department), category field (rateid -> this doesn't link to the link field in department)
