Using a lookup table to search for records

[ljevans]

I am using Access 2003 SP1. Table1 has a description field. Table2 is a lookup table that has airport codes. I want to loop through Table1's description field looking for any reference to each airport code. Can I do this with an Access query?

 

[SkipVought]

Hi,

Can't you join the two tables in a query?

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[ljevans]

There is no relationship between Table1 and Table2 other than a possible reference of Table2's airport code within Table1's description field.

 

[SkipVought]

Well then you have a useless table.

First create a table that you can use to join.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}