>>Working in VFP60... I want to get a result query that is based on a
>>SET RELATION. The common fields are part_number.
>>My result query should have the following information.
>>
>>Common Part number........parts_sold _in_1999.....parts_sold_in_2000
>>102.....................................230.............................400
>>
>>Any Ideas?
>
>What is the relation?
----
table1 - partno
table2 - partno
the relationship is partno...:)