A
Alex Pavluck
I have a table and a reference table that looks like the following:
Main table
ORGS
PROJECT CONTACT
XSA/DDF/WWS long term impact study Jay
Peterson
OSI short term outcome
Tom Jones
DDF something
else Mary Smith
Reference table
ORG FULLORG
OSI Organization1
DDF Organization2
WWS Organization3
XSA Organization4
I want to link them but I want records from the main table ORGS to
link separately with each match of ORG from the reference table. So,
in this example the result would have the "long term impact study"
listed 3 times because there are 3 organizations. The one thing that
I have going for me is that the '/' is always the delimiter between
organizations.
Main table
ORGS
PROJECT CONTACT
XSA/DDF/WWS long term impact study Jay
Peterson
OSI short term outcome
Tom Jones
DDF something
else Mary Smith
Reference table
ORG FULLORG
OSI Organization1
DDF Organization2
WWS Organization3
XSA Organization4
I want to link them but I want records from the main table ORGS to
link separately with each match of ORG from the reference table. So,
in this example the result would have the "long term impact study"
listed 3 times because there are 3 organizations. The one thing that
I have going for me is that the '/' is always the delimiter between
organizations.