Hello Everyone
training to fetch enum list from another table.
i have created a training app with one table" designation wise training" and another table is “employee training master”
i have created enum list at first table " designation wise training" like [designation]=manager, [training]=“5s,GMP,fire&safety”
now in the second table how to carry forward them like when i select designation manager all training should assign as per previously selected table enum list.
i can do this with ifs but this is not a viable solution.
If I understand correctly, you assign a list of training items to a “designation manager” in one table. In a second table, when you choose that particular “designation manager” you want to see all the training items previous assigned to that person.
In your second table, the “designation” column should be defined as a Ref back to the first table. With that you can dereference any column to get its value. You do this using “dot” notation like so:
_**[designation manager].[training]**_
The question then is are you using this list of training values in the second table. If you are including them as just information, then you could create a Virtual Column and assign its App formula an expression like the one above (adjusted for your actual column names) to show on the row.
First Thanks for your valuable responce.
yesterday i tried already de-refrance as well as select function also. will it required valid if to match exactly case?
Sorry, in my previous post I missed the word “HOW”. I meant to ask this:
“The question then is HOW are you using this list of training values in the second table?”
And I guess a follow-up to that is:
How is the [training] column defined? Is it a straight EnumList or is it an EnumList that references another table?
there was valid if expression i removed and de-reference is worked. thank you so much sir.
1 Like