Relational

[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?

 

[Duane Hookom]

Do you have two Occupation fields in your main table?

 

[Roger]

No only one - Thanks for any further help

-----Original Message-----
Do you have two Occupation fields in your main table?

--
Duane Hookom
MS Access MVP





.

 

[Scott McDaniel]

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.

 

[Tim Ferguson]

I have a relational data base with among other fields:
LnameHusband and LnameSpouse and Occupation in the Main
table.

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