I do it all the time. One thing to watch out for: Always make sure that the view you need for the second view is open.
>Hi Everyone!
>
>I have a local view lvSO, which views and updates the complete SO (Sales Order) file.
>
>I also have another local view, lvSO_Items, which views certain items pertaining to a specific SO, mentioned above.
>
>Is it proper to set the filter of lvSO_Items to a primary field of another local view, lvSO, mentioned above:
>
>"SELECT * FROM lvSO_Items WHERE SOID=lvSO.ID"
>
>Can there be any problems with this?
>
>What do you think?
>
>Thanks in advance!
------------------------------------------------
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