> > 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
Hai Anders,
I am really sorry.
Both are same files only.
I dont have a products table I only have needlesdescription table.
let me upload the sample data for 2 tables.
http://www.foxite.com/uploads/2cc465bd-6166-476a-b002-6e9f3ad83c9f.rarhttp://www.foxite.com/uploads/292f91cf-a5b8-4995-b03c-7826e34e2c3f.rar