> >
> >
> > You should also have a table "Products" where productcode is the unique primary key, + columns that describe each product. And a "Needles" table where the 'needlecode' is the unique primary key. So a complete data retrieval in a query would be:
> >
> >

SELECT * FROM Products P JOIN ProductsNeedles AS PN ON P.productcode=PN.productscode ;
> >  JOIN Needles AS N ON N.needlecode=PN.needlecode ;
> >  ORDER BY P.productcode, N.needlecode INTO CURSOR ReportData1

> > You can ORDER BY any columns you like.
> >
> > -Anders
> Hai Anders,
>
> Thank u so much for the reply.
> Yes I have a "needles" table that has the description about the needles.
> But i dont have products table.
>
> Any way thank you once again...
>
> Let me go through ur solution.
> Let y know the result..
>
> Regards,
> Chandra.


It seems that the two uploads you posted are the same file.
I copied the 313 rows into a VFP table and there are 313 unique productcodes and 131 distinct needlecodes. So there is no example of a productcode with more than one needlecode in that file.

Have you imported your Excel files into VFP or exported your VFP tables to Excel?
-Anders