Dear Sir,

I would like to use Database field lookup in FoxPro 2.0 (MS-DOS)..

Structure for database: C:\FOX\COUNTRY.DBF
Number of data records: 140
Date of last update : 05/05/2004
Field Field Name Type Width Dec Index
1 COUNTRY Character 20
2 ID Numeric 2
** Total ** 23

Data:-

1. United States of America
2. Uzbekistan
3. Australia
4. United Arab Emirates

I would like to get listing of the countries from COUNTRY.DBF with @ SAY... GET. If I type "Au" (before press <enter>) it

should locate Australia, or "United S" it should bring cursor to United States of America (just like a look-up combo box in

MS-Access etc). If I press <enter> the current country name to store in the memory variable. If I type anything else which

is not in the COUNTRY.DBF, it should store in the memory variable.

TEST.PRG
cname=space(30)
@05,03 SAY "Country : "get cname
read

Please help me out with a sample code, for the above.

Thanx n regds..

Ashraf

How are FoxPro and Adabas related ?????

hey i just wanted to introduce myself :P

I would like to introduce myself and say hello
not sure if this is the right concern to do so