Quote:On top of my head, I would have to create 200 additionnal fields in the Order Database then loop through the line items database and place line items data in the additionnal fields then exporte the file as CSV type. Just creating the fields would be quite a job! Don't you Agree?
I'm not sure how FileMaker does things. In Sesame and in MS Access, if you do an export that includes fields from both the parent and child records, it creates an export file with one line for each child, where the parent information is repeated on each line. This is exactly what Sesame wants to import. I don't know FileMaker well enough to know what you need to do to produce this type of output.
For example, if you have an Invoice #1005, with 5 related product line items, both Sesame and Access will easily produce the following export file:
"1005","ProductA","5"
"1005","ProductB","10"
"1005","ProductC","2"
"1005","ProductD","1"
"1005","ProductE","8"
Note how the Invoice number is repeated on each record. Can FileMaker produce output from related records in this way?