Multiple match conditions in a unrelated table

[mousie]

Hi All,

My database has two tables:
1. Complete Address Data
2. Address conditions.

Table 1. has verbose customer [address] data like 11 smith st, 14 Kent Rd etc.
Table 2. has [std] address conditions, ST, RD, Street, Road etc.

How can I query ALL records by field [address] in table 1 by using ALL [std] address conditions in table 2?

The address conditions can occur anywhere in the [address] string, so I was thinking about maybe a CONTAINS condition, but I'm not sure

 

[llkhoutx]

The tables have to have related field, i.e. one to one, one to many, or many to many.

Add both tables to the QBE (Query By Example) frame, then drag a field in one table to the related field in the other table. A link results. The two fields have to be the same datatype.

 

[mousie]

The tables have to have related field, i.e. one to one, one to many, or many to many.

Add both tables to the QBE (Query By Example) frame, then drag a field in one table to the related field in the other table. A link results. The two fields have to be the same datatype.

How do I access the QBE view, is this the same as design?

Can the fields be directly related as they'll never have an exact text match?