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

references
(Faustin Ngassa) #1

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) #2

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) #3

Great, it works! Thank you @Grant_Stead