Auto-Entering Information into a related record

[nightdesigns]

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.

[Geeksharka]

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.

[danjacoby]

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.