Inserting data from one table to another

[tagriffith]

I have setup two different tables:

Invoice

Contacts

What I want to do is to be able to click on the invoice Contact name and it bring up a separate Contacts list. When they click on a contact in the list it imports that data into the invoice. This allows the client to create invoices for returning costumers without having to re-enter the information.

Can someone help me set this up. I was able to do it with portals, but I am unable to carry that information over to a field.

Thanks in advance!

[mr_vodka]

Hi. You will want to use lookup fields. These fields would lookup the values from your customer table once you select one. I believe that some of the example / tutorial files that come with FileMaker ( or at least downloadable online) has examples of this if you need one.