Hi,

Is there a away to change the WHERE expression without
creating the entire view ? (I could not find any)

I have a Notes form, that need to serve 2 other forms like supplier
and one for distributor. If I use the same view for both forms then I
need to change the filter expression on the fly ?

I could NOT see away to do it with DBSETPROP() as of now.

I would need to change the actual field it instead of :

WHERE Notes.idis_sysid = ?ParentPKValue

To:

WHERE Notes.iPub_sysid = ?ParentPKValue

Thanks

Doron