> >
> >
> > 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
>
> I have imported this excel sheet to VFP database.


Then you can base a VFP report for printing or display on the combination table with productcode, needlecode.

If you want to see the needlecode that belong to each productcode, that is imply the tble that you have; it only contains a single needlecode for each of the 313 unique productcodes.
If you want to reverse that and see the different products that a needlecode share needlecode you can reorder the contents:

SELECT needlecode, productcode FROM mytable ORDER BY neddlecode, productcode INTO CURSOR Q1
BROWSE NOWAIT 

In a report (CREATE REPORT) make a group band with 'Needlecode' and put 'Productcode' in a textbox in the Detail band.
There are 131 different needlecodes in that table so on the average there will be between 2 and 3 productcodes for each needlecode.
As I said ony a few, 26, needlecodes in that table are found in you Needles table.

The productcodes are complex and I guess the letters and numbers are meaningful and are codes in themselves, known in he trade or in your company. They should probably best be split into separate columns in a Products table, or several tables, in the process called 'normalization'.

-Anders