I have a three table form. The first table is the header. The second
is the detail.
On After Start EEP I want to check if any items in the detail have a
specific text.
Below is the code:
SELECT COUNT(*) INTO vCount FROM tOrderShip WHERE Control# = .vControl +
AND OUTSHIPINV = 'OUT'
IF vCount > 0 THEN
SET VAR vOutNote = +
('I enter my text here:'+(CHAR(013)))
DIALOG .vOutNote vYesNo vEndKey YES +
CAPTION ' Click Continue to ship all items or Update to Change'
+
ICON APP +
OPTION TITLE_FONT_COLOR BLACK +
|TITLE_BACK_COLOR WHITE +
|TRANSPARENCY 255 +
|WINDOW_BACK_COLOR WHITE +
|BUTTON_YES_CAPTION &Continue +
|BUTTON_NO_CAPTION &Update +
|BUTTON_YES_COLOR GREEN +
|BUTTON_NO_COLOR RED +
|BUTTON_YES_FONT_COLOR WHITE +
|BUTTON_NO_FONT_COLOR WHITE
If any item has that text, I want to immediately go to the detail
section to do some housekeeping.
IF vYesNo = 'No' THEN
What code would I put here?
I was thinking of using the PROPERTY command to set the focus. The
Component ID is Comp_ShipRows
My goal is to force the entry person to go to the detail section
immediately, then go back to the Header once done with housekeeping.
Jim
