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

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