Do not let any software impress you!

Only let it convince your intellect.
Slider img 1
Do not look for a business paradise!

It is a waste of time.
Slider img 2
Only yourself can push you uphill.

There is no easy road to prizes.
Slider img 3
Productivity is the name of the game.

And you have to conquer it.
Slider img 4
As long as you understand it,

you will start to build your know-how.
Slider img 5
We can help with that.

We have the tools and the method.
Slider img 6

Customizing the Lookup List



When a foreign key (a field that relates the currently edited record into a form with another‘s table record) is displayed, a lookup list is automatically displayed. This automatically created list contains from the related table not only the lookup field but also any other fields of the related table that are also displaying on the form.

For example, the following snippet of code does the customization:

proc Form_Start()

     start_sql “EID_SEL“ “KOSMOS“
        SELECT PRODUCT.DESCR, PRODCUT.P_ID AS RMAT, PRODUCT.APRICE2,
        PRODUCT.APRICE
        FROM PRODUCT

        WHERE (((EIDH0.PERIGR) Like :E & “%“)
        AND ((EIDH0_AYL_PRICE.IS_VALID)=𔄙“))
        ORDER BY EIDH0.PERIGR
     end_sql

end