The db I have has 3 tables, agreements, organizations, amendments. 1
agreement can have many organizations and/or many amendments, 1
organization
can be part of many agreements. I have setup a junction table (junctionID
(PK), agreementID, orgID, combo box (so I can see the org name) using
organizations table). I use an organization subform in my agreements form
to
indicate which organizations are part of an agreement.
My organization name has 2 fields, Line 1 & Line 2. If I use Line 1 only
from the organizations table, any organizations I add, I can see.
However,
if I use a query to combine Line 1 & Line 2 (through an IIf statement to
make
up the entire organization name), and use this query for my combobox any
new
organization I add, I cannot see to use.
I’d appreciate your thoughts.
G
|
