History Table(s)

[imoree]

Hello Everyone;

just trying to figure the best design or way to go about designing this.

I am wanting to keep track of my customers orders, items the had ordered in the past and put all the information in a history table for Perhaps a Customer Relations Management Table for later use. Also, for reporting.

What would be the best way to design this from the start.

Or would this just be a Simple relations TO with CustID -- > OrderID ( by date, etc,etc)

any help of designing this from the onset will be great.

thanks again,

i

[bcooney]

Cust->Order-<OrderLineItems<-Products

No "history" table.