Value list from specified value in field
So what I'd like to do is create a value list from a table where a specific field is specific.
Essentially, I'm looking to: SELECT fullName FROM employees WHERE position='manager'; and populate this as a value list. I cannot figure out how to do this with FileMaker.
Can anyone give me some pointers?