control lookup events

[madtowng]

Hi everyone,

I have a control that uses an edit-combo lookup linked to a customer table.
I am trying to force the end user to search for an existing customer before
being able to enter a new customer.

The problem I am running into is there does not seem to be an after-selection
event that allows for a non-selection (escape pressed) or a not-found option.

I've tried placing something in the onBlur event, but this fires when the lookup
begins.

Does anyone know of a workaround ?

Thanks in advance,

Gregg

[Steve Workings]

Re: control lookup events

In the absence of an event, I wonder if some other method might help "train" the user? How about a validation rule using the Cross-file Validation feature?

Another thought is that there may be some way to trigger a value driving a show/hide of some control; they would have to go through that event's hoop before they can enter a new customer.

[madtowng]

Re: control lookup events

Hi Steve,

This is part of what I'm running into.
I have the code

var pucus = {dialog.Object}.getValue('PICKUP_NAME');
var puadd = {dialog.Object}.getValue('PICKUP_ADDRESS');
alert('Focus has been blurred '+ pucus+' '+puadd);

attached to the onBlur event, but the onBlur event fires before
the lookup has a chance to fillin the extra fields.

If I can get the onBlur event to fire after the fillin is complete,
or some work-around, I think I can then code either a popup
window to add a new location, or a button to open a window
to add a new location.

[Steve Workings]

Re: control lookup events

How about an if{ statement in your javascript?

If pucus + puaadd is blank, don't do anything.

Add a choice to your popup to "Add new" or something like that, and if "Add New" then you can branch as you wish.

[madtowng]

Re: control lookup events

Attached to what ?

I want them to start typing the customer name,
If its not there, or they don't find the right one,
then they should get the option to put in a new one.

[forskare]

Re: control lookup events

I've pondered this for a long, long time. It appears to me that since there is a lookup, there ought to be a way for the user to add the data to the lookup table. As I'm typing this, I got the idea of placing a button on the bottom of the grid which the user can use to open the lookup table, enter the data and when the data is saved and the lookup table is closed, the newly entered data appears in the grid. Obviously haven't looked into this yet but that is one way I think it could be done.

[madtowng]

Re: control lookup events

I want the option to add a new record to be available only if they are unable to find
what they are looking for.

I know we have the AfterSelect event, but I need something to work like AfterNoSelect
to make the add record option visible.

[forskare]

Re: control lookup events

My suggestion is a work around but probably not an easy one when it comes to the last part of it. Yes, I agree with you. This is one of those things that, IMHO, Alpha has got it only half done. There needs to be a property in the lookup that allows the user to add a new record to the lookup. Something like, tic a box that says, User can add new record to lookup table if no lookup is found. That would then show additional properties which would path to the lookup table, etc. It would place a button on the grid that when pressed, opens the lookup table. When the data is saved, and the lookup table is closed, the new data appears in the grid.

Maybe you or others have a better idea on how to do this.

[madtowng]

Re: control lookup events

I knew if I went to sleep often enough with this problem not being solved, the answer would come to me in my dreams.

I created a button to open a dialog to add a new record.

In the client-side show/hide expression, I used the code : pickup_name !='' and pickup_address = ''

[forskare]

Re: control lookup events

I knew if I went to sleep often enough with this problem not being solved, the answer would come to me in my dreams.

I created a button to open a dialog to add a new record.

In the client-side show/hide expression, I used the code : pickup_name !='' and pickup_address = ''

After the new record is submitted, does it populate the grid with the new record as outlined in my suggestion or do you do a lookup?

[madtowng]

Re: control lookup events

I don't have that part of the new dialog completed yet.
I'm still trying to think of a way to get what was typed into the name
control to show up in the name control on the pop-up dialog.