Does anyone know how to write a query with two tables where in one table I have a field that has words that I want to find out if they exist in the other table within the field in that table?
Example: Table 1 has the word "suture" in field Expansion and I want to mark an x in field xMark in Table 2 if the word apears any where in the Expansion field in Table 2. So if the Expansion field has a record with Vicryl Sutures in it, that record would be marked in the xMark field.
Any help would be appreciated.
Thanks, Pat
Example: Table 1 has the word "suture" in field Expansion and I want to mark an x in field xMark in Table 2 if the word apears any where in the Expansion field in Table 2. So if the Expansion field has a record with Vicryl Sutures in it, that record would be marked in the xMark field.
Any help would be appreciated.
Thanks, Pat