Export same record several times..

[Sallaman]

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

[Fitch]

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.

[Sallaman]

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, 2006 by Guest

[Fitch]

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.