AnsweredAssumed Answered

Entering fields from existing data

Question asked by seattlemac on Oct 22, 2008
Latest reply on Oct 24, 2008 by seattlemac

Title

Entering fields from existing data

Post

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?

Outcomes