AnsweredAssumed Answered

Lookup from same table

Question asked by theFox on Nov 5, 2009
Latest reply on Nov 6, 2009 by theFox

Title

Lookup from same table

Post

Hi

 

I am new to FileMaker Pro, and have a basic understanding of a relational database.  I work on the MAC and PC version.  I am busy creating a Personnel dB.  In my Personnel table I have:

ID

First Name

Last Name

Manager

 

I want Manager to be a drop down of names from the Personnel table.  Users should be able to select the manager for a new Personnel record from existing personnel records.  I want to show the First Name and Last Name in the drop down somehow. Should I create a separate table called Manager and link these tables?  What is the most elegant way to do this?

 

Thx 

Outcomes