Exported Data..

[smiffy]

When I export orders what info links the person file to the order file?

I want to be able to create a databse of customer info which will include the product category of the Item they have purchased.

This way I will be able to target my customers with specific special offers based on their purchase history.

[Jan]

There are two rows in the persons table for each order. One for the invoice contact details and one for the delivery contact details.

The links are

[Order].[InvoiceContactID] = [Person].[ContactID]
[Order].[DeliverContactID] = [Person].[ContactID]

The product details on in the order details table and this is linked to the order table by

[Order].[Order Sequence Number] = [OrderDetail].[OrderSequenceNumber]

I am working on a product to do this sort of thing, but it won't be ready until much later on in the year.

Cheers,