Using Related Rows in Expressions?
I am trying to see if I can do a ref column in a table that uses a valid if expression to only show related rows of the the row being filled out in the form. Pretty much I have
a door table with a reference column to a materials order table and when selecting the column with the references materials order, I want it to only show rows related to that Door ID and if there is none, to be able to select new to add one?
I tried different expressions and get the error message that you can’t compare text in a list.
Thanks for any help with this.