Thanks, I am probably going to try a combination of both ----- Original Message ----- From: "Victor Timmons" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Wednesday, September 10, 2003 10:49 AM Subject: [RBASE-L] - Re: Drill down in regions
> 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 >
