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
