Hi all I have to access some paradox db tables form a VFP form this is what i have done and...

1 created a paradox odbc connection to the path of the db files
2 add a database in vfp, add a conection for the remote views
3 add each paradox table as a remote view in the dbc
4 create a form in vfp to access the data,

i just need to be read only there are 2 tables now as 2 views in vfp,
fleet & unit 1 fleet can have 1 or more units
so i will like to show a form that display the fleet and a grid of all its units, i tried to make it as i do with vfp tables but cannot set indexes, and the relations in the data of the grid.

the fleet view has 2 fields fleet_prefix and fleet_number both integer for use as pk
the unit view has fleet_prefix, fleet_number, unit_number all integer
WILL LIKE to DO the following:

to make a relation on fleet str(fleet_prefix,5)+str(fleet_number,5) into fleet

and fleet to have an index on str(fleet_prefix,5)+str(fleet_number,5) tag fleet

and a form that go to first fleet and show all the info of the its units in the grid, skip to the next fleet and the grid refreshes with the units of that fleet

I have done it with vfp tables but never with views and have tried without success

thanks all