NetTalk Central

Author Topic: Select button not avalilable on the browse  (Read 3289 times)

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Select button not avalilable on the browse
« 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?)
 
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186

terryd

  • Hero Member
  • *****
  • Posts: 759
    • View Profile
    • Davcomm
    • Email
Re: Select button not avalilable on the browse
« Reply #1 on: April 14, 2011, 11:28:43 PM »
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.
Terry Davidson
Windows 10 64 bit/Windows7 64bit
Clarion 9.1.11529/Clarion10 12567
Nettalk 913
Nettalk 1015
StringTheory267/Winevent515/XFiles298/MessageBox239/Cryptonite186

Bruce

  • Global Moderator
  • Hero Member
  • *****
  • Posts: 11250
    • View Profile
Re: Select button not avalilable on the browse
« Reply #2 on: April 15, 2011, 04:59:31 AM »
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