The simple answer is, yes, you can, but you'll be limited to using that view in forms with the property.
CREATE VIEW myview AS SELECT * FROM table WHERE foreignkey=?ThisForm.ForeignKey
is perfectly acceptable with the aforementioned gotcha.
>I have a parameterized remote view and a form with private datasession. I want to have multiple instanses of the form. Therefor I cant have just a global variable for the remoteview. Is it possible to make it work with a property on the form?
>
>
>Jon
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05