RBCHARNLEY
asked on
Show parents and responses in seperate view frames
Hi
I have this idea that I would like to have two views one showing response documents and one showing parent documents. These would be displayed in two frames on top of each other.
I would like to be able to click the parent document and see the children documents in the frame below.
My ideas were to try and use the onselect command on the view to pass the universalid as an environment reference between the views then update the selection formula.
Would this be easier with embedded views? What about the @SetViewInfo command?
I have this idea that I would like to have two views one showing response documents and one showing parent documents. These would be displayed in two frames on top of each other.
I would like to be able to click the parent document and see the children documents in the frame below.
My ideas were to try and use the onselect command on the view to pass the universalid as an environment reference between the views then update the selection formula.
Would this be easier with embedded views? What about the @SetViewInfo command?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
You embed a view on a form (it dosen't work on a page) with the show single catergory formula
@If(@Environment("Document
The view embedded should be catergorised by a column containing (@Text($REF)) and contain all children documents you want to show.
Create a second view that has in just the parent documents
In the on select command of this view put
@SetEnvironment("Document"
@Command([ViewRefreshField
@Return(@False)
And in the queryrecalc command
@Command([RefreshFrame];"N
And finally the query open command
@SetEnvironment("Document"
Create a frameset and split it into two rows. Make this the default frameset for the database.
In the top row specify your view of the parent documents
In the bottom row specify the form your embedded view is on
Load your database. Now when you click a document in the top it will refresh the view at the bottom and re-filter appropriatley.
Thanks for your suggestions.