Jump 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.

Auto-Entering Information into a related record

nightdesigns
in Relationships

Featured Replies

I have a related DB off my main one that holds a user's address and any notes about them linked by their user-id. Each of the 2 fields above are in a single box (not a row of related records). I want FM to automatically copy their e-mail address over into that DB for another DB i'm developing off of the same address DB (but doesn't use the username). Ideas? Thanks.

You could 'pull' the email address from DB1 to DB2 by establishing a relationship back from DB2 to DB1, and using the Set Field script (to pull the email address) OR based on the same relationship, use a Lookup.

First of all, do these people have multiple addresses? If not, why not put the address into the main file.

Same with e-mail address (anyone with more than 1 e-mail address that they use regularly -- and publicly -- is just asking for trouble).

Putting all the relevant info into the main DB means that you can create the "new" DB by relating it to the main one.

Notes, of course (since you can have many for each person) could be in the related DB.

Create an account or sign in to comment

https://fmforums.com/topic/10369-auto-entering-information-into-a-related-record/
Go to topic listing

Important Information

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

I accept

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.