> >
> >
> > 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.rar
> http://www.foxite.com/uploads/292f91cf-a5b8-4995-b03c-7826e34e2c3f.rar


Got them. 313 rows (with 313 unique productcodes) in one table.
1447 different needlecodes in the other Excel worksheet. Of the 131 distinct needlecodes in the combination table 104 codes are not present in the Needles table, while 26 are found.
What gives?

-Anders