Link Username to record and auto fill

[yodamusic]

I have been reading all I can on creating scripts, and I'm afraid its making me feel quite dumb. I am trying to have certain fields in my DB to auto fill based on the user that is logged in. I have a "personnel" table that has a user name field, which I am trying to link to their login user name, so any info may be auto entered based on this - ie. it will fill in their full name, email, rates, etc. from the personnel page.

[bcooney]

If you have a personnel table with all the data you need, don't autofill anything. Relate back to that personnel record by populating its ID into a foreign key.

Perhaps if you tell us a bit more, we could offer more detailed suggestions.

[yodamusic]

Referring to the personnel table I understand, and I can insert that personnel info, but I'm afraid I don't know how to relate back to its ID into a foreign key? I went ahead and created a personnel ID field, as you suggested, and made it auto create a serial number, so now I have a personnel record with name, other info, an ID #, and a matching field for user name. How do I now link the personnel ID "into a foreign key"

I am researching foreign keys as we speak.

Thank you for your time.

[bcooney]

What other tables do you have besides "personnel?"

I suggest some time with the FM tutorials: http://www.filemaker.com/ten/resources/index.html#0