Linking Tables with different data

[firestorm1983]

In my database I currently have 2 different tables which are linked to my database and each contains different information with the exception of Job Numbers.

The one table (lets call this TableA) contains all of the job numbers as single numbers 105, 231, 321 ect.

But the second table (TableB) contains some values with multiple values in the same field for example 105/106/107.

Can I link TableA and TableB together in a manner such that 105 and 105/106/107 can be linked together so that all the information from both can be brought together in a single query?

 

[PHV]

WHERE InStr("/" & TableB.[Job Number] & "/", "/" & TableA.[Job Number] & "/") > 0

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886