Exporting a found set of records to a new record

[merkaba22]

I have a list view which includes simple calcs that I can first sort by manufacturer (with up to 25 products, for example) and then limit that sort by further criterion -- I want to take the data from that last found set of records and create a new and permanant record in a new layout (in a new file, if necessary).

[Fitch]

So you want to combine a group of records into one record? I would probably loop through and set the data into a global field, then go to your new record and set the global into it. Something like:

Set field [gNotes, ""]

Loop

. Set field [gNotes, Data & "

[merkaba22]

I am not sure of some things ....

in the first line, is there anything between the quotation marks?

what's "

[LiveOak]

Huh? I think you have a serious problem with nomenclature.

1 ) Do you mean a list view displaying simple calculated FIELDs?

2) Do you mean "Find" by manufacturer then limit that "Find" by further criteria?

3) Do you really mean you want to take multiple records and create one record in the same file (how?).

4) I'm not sure what you mean by a "permanent record" or by creating a record in a layout. Records are not created "in a layout". Records are created in a file (FM6), independent of which layout you are on.

Maybe you can clarify your question by describing what you are trying to do (without jargon).

-bd

[merkaba22]

1) yes

2) yes

3) not the same file -- new layout in a new file (for a PO)

4) see 3

I am trying to understand "Fitch's" script offering.

I have a file with over 200 records for "rings" with a record for each item and its associated attributes, like stones, etc., offered by a pluraity of manufacurers.

I can also see these records in a list view with specified additional criteria including a set of calcs for the ones I would like to purchase from any one maufacturer by type, etc.

In the list view I can do a find first for a specific manufacturer creating, say 45 records of the different types of rings, and then a second find by further criteria creating a set of, say four records.

I would like to create a PO that is a new record (in a new file) of all the data contained in that second find, ie. the data of those four records with the heading of the chosen manufacturer, the types of rings I chose as well as the data associated with the four records.

If I use the script "copy all files" -- I only get text. If I import the found set, I get four records again.

I need all the data from the four records, in this example, in one new record in a new layout in a new file....

[Fitch]

There is nothing between the quotes -- we're just setting the global field to empty before we start looping through the records.

"

[bruceR]

Merk I think you are on the wrong track. You should have one PO table with a related PO Item table and the 4 found records should be imported into this table after creating the "parent" PO reord. You do seem to be mixing up concepts considerably, like files and records.