Whenever I want to transfer data from multiple fields in one or more tables to multiple fields in another table I use a script to set the data in a global repeating field (kind of a temporary holding area), that is then used to set the fields in the destination table. Is this good practice? Is there a better way to script this? I've read some pretty strong opinions in the forums against the use of repeating fields except in some instances. Is my instance a "safe" use of repeating fields? Can script parameters handle this in a cleaner manner?

Thanks in advance!

It's fine to pass data with globals, repeating or otherwise. Script parameters are also fine. Use what you're comfortable with. One thing you can also do if you have a lot of fields to set, is simply pass the record ID to a field (probably a global) in the target table. Then you can "pull" the data from the source file via a relationship.

I am experiencing the same "beginner" probleme...

How do you "pull" the information once you pass the id from one table to the other ?

Many thanks

See FileMaker Pro 7 Help: Working with related tables and files > About lookups

Sweet,

I am starting to understand the strenght of rile maker, Thanks a lot.

I can now move easely the contact info to the invoice and to move people to register them in a courses. Now I am trying to add an automatic product adding button. I created a listing of all product and a button over each product. It work ok (but slow) with copy and past but I am trying to use these lookup.

In my invoice I have a itemid itemname price etc...

I want to have the itemid in the relationship with my product table, but then I have to map every itemid1 itemid2 itemid3, to the main product table. Well it doesn't work.

HOw can I creat a relation ship for a sort of repeating field ? I don't want to use repeating filed since I will need to generate quite many type of report from invoicing and all..

Thank in addvance