Question about a ref.
You would think I would know ho to do this at this point, but I have tried a million different expressions and none have worked so I’m wasting crazy amounts of time.
I have a form I am trying to put together, and I would like the first field, “Employee Name” to be a drop-down menu of options based on a ref to column in another table called “Employee Name”.
The table I am referencing is ‘Master Garden List’.
I have selected “Ref” for this Column, and then tried specifying the [Employee Name] column in both the app formula field and the Valid-If field using a bunch of different expressions which seems to verify but then don’t give me what I want.
The [Employee Name] column is NOT the first column in the table I am referencing.
I think this is the problem.
It is also not the key in either table.
It only gives me the first column in the table, or other weird things no matter what I try.
How do I accomplish this? Many thanks, Miranda