Moving data from one table to another..

[RAMArtist]

I am semi-new to FM8. I am trying to create a simple contact management database for our office. I created a "Company" table and a "Contact" table; I made them relational with the "CompanyID" fields in both tables. I would like the user to be able to press a button to insert a "New" contact (while in the "Company" table) in a new and separate window. Right now I have a portal on the "Company" table showing the "Contacts". If I go and type the "CompanyID" on the "Contact" layout it joins, but I need to get the number there by itself. I hope that makes sense. Right now they would have to click in the portal so the contact is related to the company...and then I have a go to related record script in the portal that sends them to the "Contact" layout to finish inputing all of the contact info.

Please help! Thanks!

[aldipalo]

Try this:

[RAMArtist]

This worked beautifully!!! I can not thank you enough!