Enum from Other Table

Dave_Willett · 12-09-2020 03:26 AM

Guys.
I have a table "MOT which has an ENUM field called “Who”, It doesn’t make sence to me to manually enter Staff names but instead pull the values from a different table. I see many examples on here not really helping me.
The staff table is called “StaffList” and the field I want to populate into the enum “Who” is called “Name”.

Can you guys help?

Kind Regards

Suvrutt_Gurjar

Maybe you wish to share more details if following does not work for you.

In general the expression in the valid_if of [Who] can be

StaffList[Name]

with column type being Enum with base type as Name if the [Name] column in StaffList is Name type. If it is text, base type of Who also can be text.

Please refer the point 2 in the below article.

Dave_Willett

That works a treat Suvrutt. Thank you