Hi all, I have a Service Order table with a...

[Faustin_Ngassa]

Hi all,

I have a Service Order table with a column [Technician] and a reference column [Customer Id]. I want the column Service Order[Technician] to reference a table Staff, but display only the list of Staff[Name] where Staff[JobTitle] = “Technician” and the Staff[Customer Id] = [Customer Id].

Is there a way to do it without having to create a slice of the table Staff?

Thank you

[Grant_Stead]

Yes, your would place that in the valid_if area for that column. (Basically, you’re creating the list in the valid if)

[Faustin_Ngassa]

Great, it works! Thank you @Grant_Stead