I am trying to create a simple lookup form in my old DOS informix SQL DB that I can enter a single integer that will remain the same to all records in the DB (Price of Gold) The form below is not working. I need a form that the entered integer will serve as a lookup on other forms in the DB.

database northern
screen
{
GOLD MARKET FORM
-------------------------


Gold Market : [f000 ]

}
end
tables
GOLD
attributes
f000 = GOLD.gldmkt;
end

Hi,
Please test with:
DATABASE FORMONLY
.....
.......

Gustavo.

Hi Gustavo,
There is no formonly in the database. I know it's a simple setup, I went through the manual but I am not finding the right approach.
Sam