I have two tables with an ID field and relationships are established.

What I would like is that when the fax button is clicked which opens another layout to the fax table i would like the ID & First Name last name and Company name and phone info to be carried over from the record that was being viewed in the other layout and table.

What I currently have been doing is running a script that is in a drop down list to populate the ID and person’s name, meaning I have to select from the drop down and then the info is carried over. I'm looking to automate this with the above statement. Attached is a link to the file if I wasn't to clear.

http://www.nightowlpcs.com/webdb.fp7

Pretty much go to the individual's record and click fax and the drop down list is there.

Thanks

SMS_MAIN is the HOME of the DB

Web Release of DB.zip

Like this?

webdb.fp7.zip