I wonder if I can export the same record several times with different information?

For exampel:

I have a customer namned: John Doe Adress: The street City: New York and he wants to order one thing called K1 and three of one thing called K2. All this information are in seperate fields.

I then would like to export this record to a xls or text file that are seperated and with 2 different rows (or more if they want other products as well) like this:

Name..........Adress......City...Quant.....Descrip

John Doe......The street..NY......1........K1

John Doe......The street..NY......3........K2

Of course this has to work if I lookup many records also. It works fine to get one row for every record but I need them to be on seperate rows.

//fredrik

The best way to approach this IMO is to make a separate table for your orders, which would store the customer ID (key file for relationship to customers), Quantity, and Description. Then do your export from this table.

Hi, thanks for Your answer but I still don't understand how that will help since I only want one order and not several orders or maybe I do not understand what You saying?

Edited October 6, 200619 yr by Guest

I was trying to use your terminology, but what I'm trying to say is make a separate table for the line items of the order and export from the line items table. There are many advantages to structuring your data this way.