Relational

  • Thread starter Thread starter Roger
  • Start date Start date
R

Roger

I have a relational data base with among other fields:
LnameHusband and LnameSpouse and Occupation in the Main
table. I have set a one to many relationship to the
children's table. I also have a table called Occupation
with a one to many relationship to the field Occupation.
I have designed a form for the parents and a subform for
the children. But when I select an Occupation for the
Husband and then the Spouse, the same Occupation is
entered for both. Where have I gone wrong?
 
In conjuction with Duane's comment, then you need to have 2 Occupation
fields in the table if you want to store both bits of information. For
example, you'll have Occupation (for the Primary's occupation) and
SpouseOccupation (for, obviously, the Spouse's). Change the .ControlSource
of the Spouse's occupation combo to = SpouseOccupation.
 
I have a relational data base with among other fields:
LnameHusband and LnameSpouse and Occupation in the Main
table.
Click to expand...

Given that many people have more than one occupation, and most occupations
are taken up by more than one person, shouldn't this be a many-to-many
relationship?

Tim F
 
Back
Top