R
raylitalo
I am trying to model our church records, which in my model result in multiple
many-to-many relationships. For example, Many Husbands can have Many Wives
(well, not at one time, but...) Many People may Witness many Marriages and
so on. My "tblPeople" table has an autonumber primary key field
("autPersonID"), My "joinMarriage" table has an autonumber primary key
"autMarriageID" and two long fields ("lngHusbandID" and "lngWifeID") which
reference the "autPersonID" field in the "tblPeople" table. This theme seems
to occur repeatedly in my current design. In Access 2003, using the
Graphical relationship I can set up this model by dragging and dropping in
the typical way, resulting in tblPeople, tblPeople_1, ..., tblPeople_4,
because I have placed the tblPeople table in the ERD four times to model
many-to-many relationships I am dealing with.
That seems to work ok, but when I save and close save the layout of my
relationships, and then reopen them, the relationships are redefined in ways
that invalidate my model (for example, insisting that a Witness is also the
Person Getting Married.)
I'm thinking of taking the leap to the SQL Server Personal Edition--any
suggestions or advice anyone?
Thank you very much!!
Ross Ylitalo
many-to-many relationships. For example, Many Husbands can have Many Wives
(well, not at one time, but...) Many People may Witness many Marriages and
so on. My "tblPeople" table has an autonumber primary key field
("autPersonID"), My "joinMarriage" table has an autonumber primary key
"autMarriageID" and two long fields ("lngHusbandID" and "lngWifeID") which
reference the "autPersonID" field in the "tblPeople" table. This theme seems
to occur repeatedly in my current design. In Access 2003, using the
Graphical relationship I can set up this model by dragging and dropping in
the typical way, resulting in tblPeople, tblPeople_1, ..., tblPeople_4,
because I have placed the tblPeople table in the ERD four times to model
many-to-many relationships I am dealing with.
That seems to work ok, but when I save and close save the layout of my
relationships, and then reopen them, the relationships are redefined in ways
that invalidate my model (for example, insisting that a Witness is also the
Person Getting Married.)
I'm thinking of taking the leap to the SQL Server Personal Edition--any
suggestions or advice anyone?
Thank you very much!!
Ross Ylitalo