[RBASE-L] - Re: Drill down in regions - Razzak's Reply

[A. Razzak Memon]

At 10:15 AM 9/9/2003 -0400, Joel Solomon wrote:

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.
Joel,

Welcome to the Official R:BASE List Server!

In order to achieve your goal, follow these simple steps:

01.     Design an form to display details of invoice.
        Example: InvoiceDetails
02.     Create an EEP with the following commands:

        -- InvoiceDetails.EEP
        EDIT USING InvoiceDetails WHERE InvoiceNumber = .vInvoiceNumber
        RETURN
03.     Update your original form with region and while in
        Form Designer:
        Create an expression to get the InvoiceNumber of currently
        selected/highlighted row in the form region.
        Example:

        Form Designer > Variables > Edit ...

        Define Expression:

        vInvoiceNumber = InvoiceNumber
        Variable Type: INTEGER
        Click on [Add] and then [Done].

02.     Set the Current Table to the same table used for Region

        Layout > Set Current Table ...

03.     Place a "Push Button" outside the region with the following
        properties:
        Button Details: Invoice Details
        Button Type:    [x] Custom
        EEP or Command Block: InvoiceDetails.EEP
        Click on [OK]

04.     Save the form.

05.     At the R> prompt:

        EDIT USING FormNameWithRegion

        Scroll through the rows in region via [F8] or [F7] keys

        Highlight/Focus the row you wish

        Now click on the [Invoice Details] button

        You should be able to see InvoiceDetails form for that
        particular highlighted row in the previous form region.
        Close this form.

        You'll be back to the original form with region.

That's all there is to it.

Enjoy and make sure to have fun!

On the other hand, using the Next Generation R:BASE 7.0 for
Windows, you can use the Push Buttons and more controls in
Scrolling Regions.
Very Best R:egards,

Razzak.

Unbounded Possibilities with Industrial-Strength,
True-Relational and Multi-User Database Management System