Grid Update for selected database value

Applications Forms
#1

All,
I just doing the evaluation of the product and am trying to understand how by using the grid lookup feature, it knows what is selected in the database.
i,e
html version
select option value= “”
option value ‘car’ selected
option value ‘truck’

#2

Re: Grid Update for selected database value

Hello,

Welcome to our Forum.

You can use the grid lookup feature to change the displayed value. That is, let’s say that you have a Sales table with UserID, ProductID and Quantity.

Intead of showing the UserID, and ProductID on the Grid, you can display the UserName and ProductName with lookups.

For instance, on the ProductID configuration you would set a lookup as below:

SELECT ProductName FROM Product where ProductID = {ProductID}

You can always contact our support. Our chat is active on workdays from 8:00am to 6:00pm (GMT -3), and our ticket system is always available.

regards,
Bernhard Bernsmann