Another 'database' question

[Anna]

Hi All!

I have had a request from a client for whom we built an Actinic Catalog 6 site.

She asked whether Actinic has a database with records of all orders placed that she could use instead of manually typing up customers' details in her own CRM database every time she receives an order...

I have had a look at the 3 database files within Site 1 (ActinicCatalog.mdb, Backup.mdb and Previous.mdb) - One of the tables (in each db) is called Order and there were some details in there, although I don't think I saw the customers' details.

First of all, does Actnic collect and store the customers & order info? If so, where is the data stored (database & tables)?
Can anybody help?

Please forgive me if this has already been covered.

TIA!

Regards,

Anna

[chrisbrown]

ActinicCatalog.mdb is the current database (the others are older versions as their names suggest). As you have discovered, the Order table contains details of orders. This table contains InvoiceContactID and DeliverContactID columns which are foreign keys for the ContactID column of the Person table which contains all name and address info.

[Anna]

Ta!

Chris, thanks for your reply! It was very helpful.