NetTalk Central
NetTalk Web Server => Web Server - Ask For Help => Topic started by: terryd on April 14, 2011, 09:49:34 PM
-
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?)
-
Update
If I use a drop list for the category in the PARAMETER_ItemPrices it works but this isn't totally satisfactory since the list is pretty long and I would like to do some filtering on the select list that the client sees as well.
-
I confess Terry - I'm sort of following along - but probably not exactly.
Perhaps you could make a small example demonstrating the effect? That makes it a lot easier to diagnose and (if necessary) fix.
cheers
Bruce