Hi guys,
I need help with the Validation Rule expression.
I have a table like follows:
ID
Position (lookup to position table)
Slot1 (lookup to employee table)
Slot2
Slot3
In the field "slot1" I want to lookup a name of a person in the Employee table, but ONLY IF, in a third table (Eligibility) where I say which Positions that guy is eligible for, that guy has that position in his eligibility. The validation rules needs to only allow a name be selectable if the criteria is true.
In case this helps, eligibility table looks like:
ID
Employee (lookup to employee table)
EligiblePosition (lookup to position table)
There could be multiple records per Employee if they are eligible for multiple positions.
Sorry if this is not explained clearly! :banghead:
I need help with the Validation Rule expression.
I have a table like follows:
ID
Position (lookup to position table)
Slot1 (lookup to employee table)
Slot2
Slot3
In the field "slot1" I want to lookup a name of a person in the Employee table, but ONLY IF, in a third table (Eligibility) where I say which Positions that guy is eligible for, that guy has that position in his eligibility. The validation rules needs to only allow a name be selectable if the criteria is true.
In case this helps, eligibility table looks like:
ID
Employee (lookup to employee table)
EligiblePosition (lookup to position table)
There could be multiple records per Employee if they are eligible for multiple positions.
Sorry if this is not explained clearly! :banghead:
