Setting many fields in a script

[Kent Searight]

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!

[Fitch]

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.

[damaru]

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

[comment]

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

[damaru]

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