Conditional Drop Down - Auto Fill
Hi, Hoping someone may have a solution for this. I'm sure I'm missing something simple. Table: Employee
This table houses all employees. There will never be a duplicate instance of this emp...
Forum Discussion
Can you list the relationships between the tables?
In general, you'll need to make a summary field that counts the number of active assignments, and transfer (either a summary field or lookup field depending on you relationships) that count to where the selection is made. You will also need the record ID of the active assignment, which should also be transferred to the selection page.
After that, use a dynamic form rule that says, if [Count]=1, and [Related Assignment] is blank (you can use <1 if needed), change [Related Assignment] to the value in the field [Record ID From Table that was transferred]
------------------------------
Mike Tamoush
------------------------------
In general, you'll need to make a summary field that counts the number of active assignments, and transfer (either a summary field or lookup field depending on you relationships) that count to where the selection is made. You will also need the record ID of the active assignment, which should also be transferred to the selection page.
After that, use a dynamic form rule that says, if [Count]=1, and [Related Assignment] is blank (you can use <1 if needed), change [Related Assignment] to the value in the field [Record ID From Table that was transferred]
------------------------------
Mike Tamoush
------------------------------