Windows7 Ultimate 64 Clarion7.3 7995 Nettalk518
I seem to be in a bit of a Catch22 situation
What I want to do is lookup from a form to a browse where the browse is limited to one subset and to then allow the client to select from a lookup and further restrict the browse
EXAMPLE
The FORM_Orderline form has a field with a lookup on the itemprices table where the VIEW_Itemprices browse is restricted via a filter to certain brands of products carried by the nominated supplier
So far no problem.
Now I want on the browse to have a lookup which will further restrict the itemprices browse to a selected category
So create a memory form PARAMETER_ItemPrices and populate a local category and lookup the category table using SELECT_Category
Problem here is that when the SELECT_Category lookup returns it returns to the FORM_Orderline form and not the PARAMETER_ItemPrices form which should now be only displaying the selected category items.
I understand this as Bruce explained in a reply to my email about this problem.
His suggestion was then to use a popup.
So check the Popup lookup box on the category field on the PARAMETER_ItemPrices memory form and on the form field of the SELECT_Category browse check Open form as popup.
Now selecting the lookup works fine, the screen returns to the VIEW_ItemPrices browse filtered by the selection in the PARAMETER_ItemPrices
Great except that the select button in the VIEW_ItemPrices browse has disappeared so I cannot select from the restricted list.
Anything I am doing wrong?
Or is there a workaround (e.g should I create a memory table to which I can write only the records that they select and do my lookup on that?)