I have a main table commondata that has information in two other tables,
components table and primitives, I need a count of like fileds from
commondata where the line to EITHER the compionents or primitives is good.
It sounds like the scenario we had once ... there was a table of
people; some of them had an address in a foreign country, others were
local. The addresses were split between two different tables, and
there was an ID relating the address to the person (or other entity, I
forgot what it was).
At any rate, it was a bad design since there was no way to enforce
referential integrity at the constraint level using foreign keys.
Everything was done by triggers, and Access doesn't even HAVE
triggers! ...
You could use two WHERE EXISTS (...) criteria with a correlated
subquery on the two different tables. If the data is consistent, that
should work pretty well. But enforcing RI with this design is pretty
yucky.
