It depends on what you want to do with selected records.
>
>Thanks for the links.. I am looking them over.
>
>I wonder if you might help me with my problem at hand.
>
>I have 2 differnt tables, each have differnt field names but there is one common field between the two. This would be vnd_id
>
>What I need to do is take a slection of the fields from each table where the vnd_id is the same.
>
>I have came up with this lol ....
>
>CLOSE ALL
>CLEAR ALL
>CANCEL all
>CLOSE DATABASES
>
>USE i:\ronnie\povnda1.dbf IN 1 EXCLUSIVE
>USE i:\ronnie\povnst1.dbf IN 2 exclusive
>USE i:\ronnie\orcfocus.dbf IN 3 EXCLUSIVE
>SELECT 2
>SET ORDER TO VND_ID && VND_ID
>SELECT 1
>SET RELATION TO vnd_id INTO 2
>
>
>If I browse 1 and 2 then If i click the vnd_id I'm able to see it move around....
>
>I have spent hours just learning the syntax I just need a little help as to how to accomplish this.
>
>Thank you again,
>Ronnie
--sb--