match records from two tables

[midnite]

Hello, I would like to match records from one table with records from another one. The problem is that all records in both tables are products with different names, packages, e.t.c.

I have created a relationship and manually enter the record id of table1 to products of table2 and then with portal table view the match, but I would like also to perform a search to find similar records from these two tables based on some criteria that I established. For example, I created a field in each table with mixed information from various fields of each table and I would like to see whether there is any match or not.

Thank you very much

[ClayTarver]

Do both tables contain fields that describe the same attibute, e.g. color or material? If so, you can relate the two tables using these fields. For instance, in the following, Table 1 record 3 matches Table 2 record 76.

T1 T2

# color material # color material

1 red leather 67 blue PVC

2 red wool 76 red PVC

3 red PVC 231 blue wool

4 blue PVC 433 green leather