Lookup from same table
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:
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?