Hi Mark,

You are correct, I will have to change the design of the Notes
table.

Thanks

Doron

>>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