Adding a range of records at one time

[DFehrenbach]

I have a Master table of test names that I want to copy into another table, one record in the second table fore each record in the Master Table. I previous versions of FM I would just import the fields from the master file into the second file, but am at a loss to know how to accomplish this in the FM8. Can anyone please suggest a solution?

Thanks!

[Genx]

Before you do this, why are you doing this?

[Genx]

Anyway, once you work out why your doing it... i'm sure theres some sort of valid reason even though filtering etc. could be accomplished via extra fields rather than additional loads of data...

Freeze Window

Loop

SetVariable[$Field1 ; Master::Field1]

SetVariable[$Field2 ; Master::Field2]

SetVariable[$Field3 ; Master::Field3]

...

Go To Layout[Your Slave Table] (seeing as we're using the terminology )

New Record / Request

SetField[slave::Field1 ; $Field1]

SetField[slave::Field2 ; $Field2]

SetField[slave::Field3 ; $Field3]

...

Go To Layout[Your Master Table]

Go To Record [Next ; Exit After Last]

End Loop

Alternatively, you could just export the data and re-import it into your second table.

~Genx

[DFehrenbach]

I tried using the import step, but would not work for me. The Master Table contains more records than just those I want to import. When I import them, I get all the records in the file (despite the fact that I use the proper Table occurance that would give me only the records I want - The TO uses a self-relation using a global value. CAn the Import be limited to only the records in a TO?

[Ender]

Hi Dennis,

An Import between files/tables is still the most efficient way to move a large number of records from one file/table to another. There is no need to export; just import directly after getting the correct found set in the source table, then switch to a layout in the destination file and use the Import menu item or script step and match up the fields from the source table to the destination table. For this to work, the source table can only have one window open, else it imports all records from the source table.

But Genx's initial thought is important. In general, having the same records in multiple tables should be avoided. There are some exceptions, but the practice of relating to the original records should be considered first.

[Genx]

Didn't know you could import directly that way...