Hi
I am new to file maker and I am trying to convert a access data base to
Filemaker.
I am encountering a problem on how to copy the portal data of a record
to the portal data of a new record.
I have a table that contains the batch informations and a table that
contains the ingredients used for the batch. Both table are link
together by the batch number field. I have a layout that display in a
portal for each batch the ingredients used for this particular batch.
How can I make a script that will enable me to copy the ingredient used
in a specific batch into the portal of an other batch?

Any help is apreciated.

I assume your displaying the portal of ingredients from the Batch
record.
Create a script that goes to the related ingredient records for the
original Batch record, so your now at a layout displaying ingredients.
Loop through the records and set a global text field to the ingredients
separated by carriage returns.
Go back to the Batch record and set a global number to the ID of the
new Batch record.
Go back to the Ingredients screen and create records until the global
text field is empty by creating an ingredient record, setting it to the
first line of the global field, removing that line of the global.
You'll also have to set the Batch ID in the newly created records.

If you're using FM7 or 8 you could simply create a utility table in one
of your files, import the ingredient records into it, and from there
back into the ingredient file.

I am using filemaker 8. I am going to try your second solution that
looks simpler.

thank you


FP wrote: