Actinic and Access database relationships

[AsleepATheWheel]

Hi,

I'm wanting to get a bit of information out of the Actinic Access database. Is there anywhere that ties in the information in Actinic with the various tables found in the Access database? I've sussed out some of them, but the relationship between some of them is quite difficult to work out.

Cheers,

Paul

[cdicken]

These are the key ones off the top of my head

Products - 'Product' table
Sections - 'Catalog Section' table
Components/Attributes/Choices/Custom Properties/Quantity Dependent Pricing - 'ProductProperties' table
Main Order Details - 'Order' table
Order contents - 'OrderDetail' table
Customer details - 'Person' table
Payments - 'PaymentHistory' table
Main customer account details - 'Customer' table
Customer account address details - 'Address' table
Customer account buyer details - 'Buyer' table

How's that?

[AsleepATheWheel]

Thats great, thanks, I've found another couple I was after as well.

Cheers,

Paul