Check Product Hide HTML when parent section hidden

[graphicz]

If a section is hidden its child products are also hidden but their 'Hide on Website' box is not ticked. Thus if you run an SPP converter or similar the previously hidden products become visible as they have been moved from their parent section.

I would like a way to cascade a Section's 'bHideOnWebSite' to the product's 'bSuppressHtml'

This is so the SPPs would be generated but the products remain hidden

Please can someone help me write an Access query along the following lines:

• If Table Catalog Section bHideOnWebSite is checked
• then Table Product check bSuppressHtml

I am afraid I am not competent to do this on my own!

Thank you

[graphicz]

OK. Let me try anmd be more specific.

In The Catalog Section Table you can find the Section IDs of the sections that are 'Hide on Website'

The Product Table has a column for Parent Section IDs (nParentSectionID) and the column for hide on website (bSuppressHtml)

Either in Access or Excel is there a way to say:

for an array or selection of values of 'nParentSectionID' change to respective values of 'bSuppressHtml' to true

Thank you

[John Ennals]

I think you'd need to create an Update Query like this (but I haven't tested it):


John

[graphicz]

Smashing - thank you so much John