Creating a dropdown list from unrelated table
Is it possible to create a dropdown list from a field in an unrelated table in FMP11? Example: I have an employee directory database already in place. In the database I'm creating, I want to automatically fill in a dropdown box with the employees from the directory. This way, when a new employee is created in employee directory, his/her name will also show up as an option in the dropdown list of the new database. Is this possible? What are my options?