Call lookup pop up on field selection

[CaseyR]

Hi, Bruce

Is there a way to trigger a pop up look up when the user selects a field?  I force the users to use the lookup for accuracy and filtering reasons.  Autocomplete works fine for most fields but for some it isn't flexible enough for some.

Using 9.31 at the moment.

Thanks.

[Bruce]

Hi Casey,

Can we narrow down the spec a bit?
I presume it should only popup the lookup automatically if the field is blank?
This could be done, but I'd need to figure out a couple lines of JavaScript for you.

Alternatively, what it can do now is auto-popup when a form opens in Insert mode. That's already supported. But it happens when the form opens, not when the field is selected.

cheers
Bruce

[CaseyR]

Thanks, Bruce.

Yes you are right it is only needed when the field is blank.  I wasn't able to use popup when open on Insert because the form uses an In Memory table to receive the input and is always in Insert mode.

There is another alternative that would work for me.  For auto compelete,  an embed or template entry that can be used to further validate records after they have been filtered.  The function I have for the lookup is too complex to be run efficiently in view filter.

Thanks again.     

[CaseyR]

Of course there is an embed point to validate autocomplete if you look for it.  Sorry