With a SELECT - SQL statement, you can create a read-only cursor based on more than one table.
If you need to update the tables, use a view. The view has to be saved in the database; the tables can be free if you like.
Another option is to work directly with the tables, without queries or views. Use the SET RELATION command to select the appropriate record from table "B", every time the record pointer changes in table "A".
>Hi all
>I have two table :
>
>Table1 ( acode n(2,0) , aname c(10))
>Table2 ( acode n(2,0) , bname c(10))
>
>i want to have a grid with three column : acode,aname,bname
>i dont want to create and use from CURSOR. i want to use from table1,table2 fields directly.
>can i do this? if yes, how?
>Thanks
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)