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
