Entering fields from existing data
I'm trying to build my first database with FileMaker 9, and I'd like to add a feature I can't figure out a solution for.
There is a "Users" table and an "Issues" table, with a matching userID field in each table. Each issue belongs to the user who reported it.
One user may report several issues. When adding Issues records, rather than remember the userIDs I'd like to be able to select a name or userID from a list or popup menu in the Issues layout to assign the user for that Issue (once the user record has been created the first time, of course). What would be the best way to approach this?