Darn it!!! On 11 Sep 2003 at 19:27, Tony Luck wrote:
> OOOOPs' > > Sorry Victor that was an RB7 way not 6.5 my mistake.....just in RB7 you can > have the effect of just clicking on a row of data in a region and assign an > eep to drill down as deep as you want... > > 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 > > Victor Timmons Tiz's Door Sales, Inc 425-258-2391
