nuBuilder Forum

I would like to display looked up values from another table in Browse Form Column.

I followed the Tutorial but could not figure out how to have a SQL like follows as the DISPLAY criteria:
SELECT prt_type FROM producttype WHERE prt_typeid = pro_type

If I enter a SQL statemement like this, from the error message it appears that teh code tries to embed my SQL statment inside another SELECT statement which convers the whole form and then fails.

In your tutorial, it is shown as just IF THEN statment and embed the values in the statement. I want the values to be looked up from another table.

jk

jkdev,
you have to get values from the producttype table using JOIN in SQL field: So in Browse Display field you can simply insert the producttype field name: Hope this helps,
Max

Thanks! Got the concept now.

.