Right im fed up now.
I have a table of properties and a table of customers with requirements. I want to match records of properties that meet requirements of a purchaser and store them in another table., but not more than once

Create a one to many relationship between the customer and requirements tables. Use a junction table between the two if you don't want to create multiple requirements records which are identical other than the link to the customer table.