I have a column with type Ref. Right now it shows a dropdown of all the rows in the ref’ed table, since I don’t have a column on the form that has the same value as the key on the ref’ed table. (Don’t ask).
I do want to narrow down the rows shown, however. Kind of like showing the user a slice of the ref’ed table, where only those rows are displayed where a certain column matches a value I’ll specify (actually the value in a column on the form).
Can I specify this as an expression on the Ref-type column definition itself?
I have a feeling I should know this but it’s getting late and I’m getting punchy…