Hi there-
I think someone will have fun with this one. I've looked all over, but couldn't find a technique to get this done (even though it sounds like it should be easy). I'd appreciate any suggestions you can offer:
I have a Grid with an "Edit Combo" Lookup field (only a single field is displayed) that's working perfectly. If the user clicks the dropdown arrow, a list of available choices is shown. The user can click one the choices or can manually type an entry that's not in the list. Everything is working the way I'd like, except that I would like the user to be prompted with a question like "Would you like to add that to the Master List?". If they respond "Yes," then whatever was manually entered into the the field would create a new record in the SQL table that supplied the lookup (Ajax Callback), so that it would appear in future lookups. NOTE: The SQL table has only this field... and was created just for this lookup.
I was trying to use the "NotInList" command to call an XBasic function with an "INSERT" SQL statement, but I don't know how to create the "prompt" where the user can choose whether to add the record to the list or not (e.g. it's a one-time description that won't be used again, so we don't want to add it to the Master List). I don't know how to pop-up the "Do you want to..." question and how to translate the response into the XBasic function.
If you could offer some suggestions or guide me in the right direction, I'd appreciate it.
Have a great holiday weekend.
Phil
I think someone will have fun with this one. I've looked all over, but couldn't find a technique to get this done (even though it sounds like it should be easy). I'd appreciate any suggestions you can offer:
I have a Grid with an "Edit Combo" Lookup field (only a single field is displayed) that's working perfectly. If the user clicks the dropdown arrow, a list of available choices is shown. The user can click one the choices or can manually type an entry that's not in the list. Everything is working the way I'd like, except that I would like the user to be prompted with a question like "Would you like to add that to the Master List?". If they respond "Yes," then whatever was manually entered into the the field would create a new record in the SQL table that supplied the lookup (Ajax Callback), so that it would appear in future lookups. NOTE: The SQL table has only this field... and was created just for this lookup.
I was trying to use the "NotInList" command to call an XBasic function with an "INSERT" SQL statement, but I don't know how to create the "prompt" where the user can choose whether to add the record to the list or not (e.g. it's a one-time description that won't be used again, so we don't want to add it to the Master List). I don't know how to pop-up the "Do you want to..." question and how to translate the response into the XBasic function.
If you could offer some suggestions or guide me in the right direction, I'd appreciate it.
Have a great holiday weekend.
Phil
Comment