Help needed in linking Actininc database MS Access fields for a report

[skinnybloke]

Hi - I want to create a report using from the Actinic database using MS access. I want to show product number, product name, product image name and the html page name for that product.

The information seesm to be in the "Product" and "filelist" tables.

Does anybody know what I need to create a relationship between to link these together.

TIA

[Jan]

'product number', 'product name', 'product image name' are in product


'html page name' is in CatalogSection

Join them together using CatalogSection.nSectionID and Product.nParentSectionID, products in the top level section have 0 or NULL for nParentSectionID.

BTW I have a report in my free library that will give you this information in the form of a sitemap.

Regards,

[skinnybloke]

Hi Jan - sounds good - I'll take a look at that - thanks