Table links ActinicCatalog.mdb

[June]

Hi,

I would be grateful for any help on this. We are trying to work out the tables relate to each other within the Actinic database so we can set up a database to import products.

We are a bit stuck on the following:

Can anyone confirm if this is correct:
The tables in the Catalog Section and Product (Related to Catalog Section) are clearly related.

The relationship seems to be that n ParentSection ID links to n Section ID on Catalog

Could you supply any details on this, please??

Many thanks

[DaveT]

That is correct. And the top sections have nParentSectionId of 0.

And if you need it, Order joins to Order Detail by the OrderSequence and Order joins to Person from [Order].[InvoiceContactID] to [Person].[ContactID].

[June]

Hi Dave,

Thanks for your help, that's great - I can't find any information on this in any of Actinic's documentation - can you point me in the right direction on this, if we need further info?

Thanks again

[DaveT]

Absolutely - please feel free to ask anything.

[Mike Hughes]

If you contact Actinic they'll help you out with the database documentation.

See: http://community.actinic.com/showthread.php?t=12744

Mike