FMP 8: by script, I find one or more records in a list layout (mostly
less than 10).

For every found record I need a child record in a different table. How
shall I do that?

A) Go to the other table and import the records looks easy (but there
will be problems if someone changes the name of the file).

B) Export serial no to a csv, go to the other table, import the csv:
trouble ahead in a network?

C) Loop through the recors, grab the serial no. with a variable, go to
the other table, create a new record, insert variable, go back to the
first table, go to next records: Looks like fun - maybe a performance
issue?

Any suggestions?
--
http://clk.ch

How about using a Portal?

G

Christoph Kaufmann wrote:

"Grip" hat geschrieben:

[How to create a child for every record in a found set]
Is there a script step for the creation of a portal row?
--
http://clk.ch

Christoph Kaufmann hat geschrieben:

Oh my - it isn't when I try data seperation. The found set is in the
interface file, whereas the import source has to be the data file, and
there's no found set there.
--
http://clk.ch

Christoph Kaufmann wrote:
You can do your import completely from within the interface file. As
long as you have a Table Occurrence set up in your interface file for
your source and target tables, you can just get your found set in the
interface file and do the import.

For nearly all purposes, there is effectively no difference between a TO
in one file and the actual data table in another file. No speed
difference, no referential difference.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Howard Schlossberg (818) 883-2846
FM Pro Solutions Los Angeles, California

FileMaker 7 Certified Developer
Associate Member, FileMaker Solutions Alliance

Howard Schlossberg <howard (AT) antispahm (DOT) fmprosolutions.com> hat
geschrieben:

I bang my forehead - thank you. I did not try that because it's way
too simple.
--
http://clk.ch

Go to Portal Row [First] works as does
Go to Field [Field in portal]

G