Linking Tables if not exact match

T

tuxaby

Help!! We have two tables - the first table contains single values of
information (i.e. 111, 112, 113, 114). The second table contains text that
would include that information (i.e. "On invoice number 112 the part was
purchased"). How do we pull in the infomration from the second table that
contains the field from the first.

(for example the second table states the person who wrote the text - we want
to pull in all people associated with invoice number 1112).

Is this possible - if so how?

Thank you!
 
Top