Tony Can you please clarify what you mean? "Over the region row" - does this mean it is OUTSIDE and ABOVE the region, but associated with the same table? Or IN EACH ROW in the region?
And how would the user's clicking ON THE ROW launch the eep in the BUTTON? David Blocker ----- Original Message ----- From: "Tony Luck" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, September 11, 2003 5:25 AM Subject: [RBASE-L] - Re: Drill down in regions > Victor, > > I use a BIT BUTTON and place it over the region row so if the user clicks > on the row it launches my desired eep. > > > At 07:49 AM 2003-09-10 -0700, you wrote: > >I like Razzaks method of drill downs but here is my twist on it. > > > >I have forms with a regions and form var's that match the column that > >holds the information id the user would like to drill down into. When then > >user > >clicks on that cell in a column it brings up a Menu that askes you how you > >would like to view the data. Then it loads a different form with your data. I > >feel that this approach give you many different ways to let the user drill > >down > >into your data. This also works on forms without regions. You can add the epp > >to your cell of data and then clicking on the cell will bring up your > >choices. > >The only problem with with running the epp from the cell of data is timing, > >each time you land on the cell it fires off the eep because there is no > >double > >click event in rbase. So the basic logic logic of both methods combined would > >probably be the most flexable. Creat buttons and add menu that pops up > >when you > >click that button that alows the user to veiw the data in many different > >ways. > >Below is some simple code for you to check out. > > > > > >----------------------------------------------- > > > >--InventoryBinEdit.Men > > > >COLUMN |-Please Select-| > > > >|Edit Bins in Selected Rack| > > > >|Edit Bins in Selected Area| > > > >|Close| > > > >ENDC > > > >------------------------------------------------ > > > > > > > >CHO vX1 FROM InventoryBinEdit.Men > > > >IF vX1 = 1 THEN > > > > EDIT USING InventoryBin ORDER BY RackName1,Level,SortOrder + > > > > WHERE RackName1 = .vRackName AT 10,10,650,540 NOHEADER > > > > GOTO Done > > > >ENDIF > > > >IF vX1 = 2 THEN > > > > EDIT USING InventoryBin ORDER BY RackName1,Level,SortOrder + > > > > WHERE RackName1 CONT .tDeptID AT 10,10,650,540 NOHEADER > > > > GOTO DONE > > > >ENDIF > > > >IF vX1 = 3 THEN > > > > GOTO Done > > > >ENDIF > > > > > > > >LABEL Done > > > >CLEAR VAR vX1 > > > >Return > > > > > >On 9 Sep 2003 at 10:15, Joel Solomon wrote: > > > > > Hi, > > > > > > I am new to your community and want to thank you for allowing me > > access. I > >have a question regarding regions. > > > > > > I have a region set up that shows all the invoices for a particular > > customer. > > The region shows the invoice date, number, sales amount, tax amount, fright > >amount and total due. I want to "drill down" from any of these invoices > >to the > >detail of the invoice. I am not sure how to attack this. > > > > > > Thank > > > Joel Solomon > > > Controller > > > Barbizon International > > > > > > > > > > > > > >Victor Timmons > >Tiz's Door Sales, Inc > >425-258-2391 > > Tony Luck > Brisbane Australia > >
