I have a photo library that I am looking to publish to the web via FWP. The db publish well except that there are certain Records that I do not wish to publish.

I thought of adding a new field that indicates that the Record should not be published and then create a new table that publishes only the Records that do not have this 'flag'.

Now the question is 2 fold. Is this is good thinking? How do I make it work?

Hi

My thoughts on this is to create a second table that is related to the photos and use this second table to publish only the related records to the web. So if the relationship was like this

WebTable::Publish --> PhotoTable::Publish

Y Y = Show

Y N = Hide

This side is set to Y This side is set to Y if you wish to display and N or anything else for that matter if you do not wish to display

Regards

Phillip