Hi again,

I have a main table, Policies, which contains general
information pertaining to all policies regardless of their
type (i.e. LifePolicies, MotorPolicies, HouseholdPolicies)
and also three other tables, Life, Motor, Household which
contain *additional* specific information about the
policies belonging to a particular type.

The database schema can be found at:

http://www.databaseanswers.org/data_...surance_broker
s/index.htm

Because I could not figure out how these four tables are
related among them in the above mentioned schema I posted
a question (see: "unknown symbol in ER diagram", "george",
Feb 21/2005, 2:20 AM) and it was kindly explained to me
that this is a supertype - subtype situation involving a
1:1 relationship between each one of the three subtables
and the main table and also the use of some triggers.

Well, all this I think is above my ability to apply as I
am not experienced in SQL programming but I nonetheless I
really like the idea of having three 1:1 relationships
that are mutually exclusive because of the triggers since
conceptually this is exactly what I need.

Are there any ideas for any workarounds? Myself I was
thinking (as a last resort) to create three 1:M
relationships and then somehow put some code on the forms
of the three subtables which would not allow the user to
add more than one record, but, I don't know, I'm kind of
desparate right now.

ANY IDEAS OR HINTS that you may have on the subject will
be greatly appreciated,

thanks in advance, george