Link to home
Start Free TrialLog in
Avatar of RBCHARNLEY
RBCHARNLEYFlag for United Kingdom of Great Britain and Northern Ireland

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?
ASKER CERTIFIED SOLUTION
Avatar of mbonaci
mbonaci
Flag of Croatia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of RBCHARNLEY

ASKER

Okay here it is

You embed a view on a form (it dosen't work on a page) with the show single catergory formula
@If(@Environment("Document")="";"";@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";@Text(@DocumentUniqueID));
@Command([ViewRefreshFields]);
@Return(@False)

And in the queryrecalc command
@Command([RefreshFrame];"Notes")

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.