Hi everyone,

I'm confused as to wher to post this (relationships forum or here), but I think the issue has to do more with exporting.

I have a file where one person can have as many as 10 different machines. There are 10 fileds named "M1" through "M10", and each person is one unique record.

Now I want to export this data as One-to-Many relationship, where all machines will show up in just one field names "Computers". Kinda like portal view, where all machines belonging to one person appear in one column.

I realize this is structurally insane, but has anyone ever had to do this?

Thanks for the input!!

If I understand correctly, you want to move to a structure with a file for Persons and another related file for Machines and need to export the data currently stored in 10 fields as one record per field (M1 thru M10). To get the data into your new Machines file, you will need to perform 10 finds (in the current file) and 10 imports (from the new Machines file).

Step 1: Find all the records with data in M1. Perform an import of these records into the Machines file.

Step 2: Find all the records with data in M2. Perform an import of these records into the Machines file.

.

.

.

Step 10: Find all the records with data in M10. Perform an import of these records into the Machines file.

In each case, import only those fields needed to populate the Machines file. The file match will be slightly different in each case, as data is stored in a different field at least for M1 through M10.

-bd

Thanks LiveOak,

Is it possible to export conditionally in a script? Will FileMaker remember multiple export orders in one script, like:

Case(M1="something",

Export Records(specific order of fields, no dialog),

M2="something",

Export Records(different order of fields, no dialog),

....

M10="something",

Export Records(different order of fields, no dialog))

Actually, if I want to export all this to Excel, after exporting to .dbf I need to always update the field heading