lookup object value

[amtbox]

Hello !
How to display the value of a lookup object on an text or display object of the same form ?
Thank you for your help

[admin]

amtbox,

You'll need to explain more.

Steven

[amtbox]

On a form I have a lookup connected to table (eg. product) that shows the code and the designation of the product. I want use in SQl query the product identifier chosen this lookup before clicking save button.

[admin]

amtbox,

Still dont get it, maybe use pictures..

Steven