Where in the database is the price flag?

[pharry]

I want to exclude all the clearance-priced items from special customer pricing. In other words, I don't want to put a customer discount on top of the clearance price. I have well over 1000 of these products, so I don't want to edit each one in Actinic to un-tick the customer price "enabled" box for each and every product. I'd rather do it in Microsoft Access. But I can't find the fields. What table are they in?

[Jan]

The product properties table, however the rows are only created the first time you untick the box, so I think you might need to do this the long way around.

Export, change and import might make is a little quicker.

Regards,