Lookups returning to the wrong screen

[terryd]

WindowsXP SP2 Clarion 6.3 Build 9056 Nettalk 5.06

I have an orderForm with a field StockItemID (call this form1)
The field is a string with a lookup onto a memory form (call this form2)
On Form2 I have 3 fields which are lookups used to limit a browse. (unfortunately I can't use drops because the tables being looked up are too large)
If I use any of these lookups they work fine but the system returns to form1 rather than form2 after each lookup
Is there any way to get the system to return to form2?

[Bruce]

Please post an example Terry.

Cheers
Bruce

[terryd]

Hi Bruce. I have slightly modified example 33 to show my problem.
I have added a table List with a lookup which requires the alias number in one of the fields.
If you run the WebApp
Select My Test
Insert
enter any name in last name
use lookup button on update list form
Use lookup button to select a Mailbox
Select Mailbox 9 (Charles)
The app returns to List Form (there is no value in the alias number field) rather than the memory form where a filtered browse of aliases should appear.
If you click the lookup button again you will see the filtered browse.
Select any alias from the filtered browse and you return to the update list form again with the correct information in the alias number field.

What I want to avoid is the first return to the Update list
Unfortunately the tables I want to use to filter the browse are pretty large so A drop list doesn't seem to be practical.


[attachment deleted by admin]

[Bruce]

Hi Terry,

ok, I see what you mean, you have a lookup, on a lookup.

One small bug in your example (which didn't affect what you were showing) was that the loc:MailBox field on the FormMemory_Mailbox procedure should "reset" the AliasBrowseControl field.

If that is on, and the Lookups are done in _popup_ mode then it works.

In page mode it doesn't work because the lookup settings are not re-entrant. I'll look into that, but it's quite a big change. Would your system work with the lookups in popup mode?

cheers
Bruce

[terryd]

Thanks Bruce
I'll test using popups.