DataBase - Dexterity Scrolling window Lookup button problem!

Asked By swethaher

09-Dec-08 03:39 PM

Hi,
I am creating a new window with a scrolling window.
There are four fields in the scrolling window. 'From Item No:'  , 'U Of M',
Qty and 'To Item Number'.  The 'From Item No:' and ' To Item No:' fields have
lookup buttons linked.
PROBLEM FACED:
I have two lookups one for 'From Item No:' and one for 'To Item No:'. I am
using 2 different local fields  in the scrolling window to store the value
returned by lookup buttons.
When the user selects a 'from item no:' using lookup button. It fills the
From Item No: in scrolling window with the one selected.Also  he is able to
enter U of M and QTY in same line.  But once he clicks on the second lookup
button to select the 'To Item No:', it fills the 'To item no: field' in
scrolling window but it changes the  selected 'From item Number' U of M , Qty
fields  in the same line to blank. Why is this happening?

That is , Why is it changing the other fields in the same line to blank ,
when i select a value from the second lookup button? I am using different
fields for 'From Item Number' and 'To Item Number',  and also linked it to
diffrerent lookup buttons?

I am having this problem when i use two lookup buttons in scrolling window.
I set created a scrolling window as Adds allowed. Is it something to do with
the linked table?

Also my menu items Insert row, delete row are deactivated . How can they be
activated?

Thanks
swetha
--
swetha
--
swetha

09-Dec-08 04:38 PM

Swetha,

You have to change your approach as this is anti-Dexterity development best
practices. In principle, what's happening to you is that the lookup window is
not returning the focus to the field on the scrolling window line, which is
causing the field to go blank.

1) Put 2 lookup buttons outside of your scrolling window (Lookup Button 1
and Lookup Button 2, for example) on the main window, next to the header
columns for From Item and To Item respectively. Take a look at the Invoice
Entry form in GP (Transactions > Sales > Invoicing) for how the layout would
work.

2) Put 2 lookup buttons (Lookup Button 3 and Lookup Button 4, for example)
inside of your scrolling window beneath the Big Line Item area (if you have
one) or beneath the Small Line area if this is all you have. Of course, these
will not show up in the lookup.

3) Link Lookup Button 3 to the From Item field in the scrolling window
4) Link Lookup Button 4 to the To Item field in the scrolling window

5) Add the following code to Lookup Button 3

run script field 'Lookup Button 1' of window 'The Main Window'; {this is the
outer window containing your scrolling window}

6) Add the following code to Lookup Button 4

run script field 'Lookup Button 2' of window 'The Main Window'; {this is the
name of the window containing your scrolling window}

7) Close your scrolling window and add the following code for Lookup Button 1

open form 'Your Lookup Form' return to 'From Item' of window your_scroll;

8) Add similar code for Lookup Button 2 pointing to your 'To Item' field

open form 'Your Lookup Form' return to 'To Item' of window your_scroll;

Please refer to the Dexterity Programmer's Guide volume 1 and 2 for the
proper techniques.

Best regards,
--
MG.-
Mariano Gomez, MIS, MCP, PMP
Maximum Global Business, LLC
http://www.maximumglobalbusiness.com
The Dynamics GP Blogster at http://dynamicsgpblogster.blogspot.com