T>>>The initial grid when double clicked goes to teh proper page and everything is fine. If you then click off that page to another tab (#5) in question, the page does not switch. The cursor will show up in the location on page 5, but that is in the middle of a grid on page 3.
>>>>
>>>>
>>>>Any ideas on this?
>>>>
>>>
>>> I normally see something like this when I think I put controls on Page 3 (for instance) but in reality it's on the main form, not the pageframe. It looks OK on the development screen but not when you run it. You can normally tell by clicking on the control and seeing where in the properties list it shows up. Just an idea...
>>
>>Well the Z-Order shows that it's on page frame on page 5. This textbox only show up on page 5 and no others?
>
>Sounds like the forms .LockScreen property got left as .t. somewhere. Try setting it to .f. in Page5.Activate.

That seems to be working. I never thought to issue that, but a quick test and poof! It's fixed.

Thanks.

I have the KLUGE for the open orders working now. It's a 2 pass SQL now.

There is a database called PO1. It's a join between my MASTER2 & your SOTRAN.
There is a local view that binds PO1 to RODETAIL. We only use 2 routes so that view specualtes one of them.

User enters the PO# in a text box and press a button 3 or 4 seconds later the grid is populated. I have a configuration button that grabs the memo from SBT's SOTRAN01 with TIW's confurators output. Now customer service can see all items of a PO their status in the plant, and look at a configuration if one is held up somewhere.

Im not sure if it will fly for your use. Here is the code from the FIND PO button:

SELECT lv_master2_shipping.crea_date, lv_master2_shipping.styledesc, ;
lv_master2_shipping.sono as sononum, lv_master2_shipping.lineno,;
lv_master2_shipping.wono, lv_master2_shipping.ponum , ;
Sotran.sono, Sotran.opno as opno, sotran.t_date, lv_master2_shipping.color, lv_master2_shipping.custno ;
FROM force ves!lv_master2_shipping left outer join f:\tiwvan\sotran ;
on lv_master2_shipping.wono = sotran.sono ;
WHERE lv_master2_shipping.wono = lcpo ;
group by 3,4 ;
into cursor po1
sele v_po_found

requery()

if _tally =0
t5=mesbox('Nothing matching that #')
This.Parent.Ctextboxl1.TextBox.setfocus()
else
This.Parent.Ctextboxl1.TextBox.refresh()
This.Parent.cGridList1.setfocus()
endif