>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

Doron,

I understand that you may not be able to change the notes table layout, but if you can I would suggest the following structure:

Notes.Id
Notes.Parent_Table
Notes.Parent_id
Notes.Note

With this kind of layout the where clause of your view would be

where notes.parent_table=?cParentTable and notes.parent_id=?parentid

Mark