Skip to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Link Username to record and auto fill

Featured Replies

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.

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.

  • Author

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.

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

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Account

Navigation

Search

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.