Help...

[Samurai]

hi guys! I have 2 tables, [MembersData_Table] and [Spouses_Table].. I made a
form based from the [MembersData_Table].. I created a relationship between
these two tables by relating the fields [Name](each table has a field named
[Name]). Then, I made a subform based on the [Spouses_Table]...What I want to
do is have a name entered in the [Name] field in the main form(so it will
come out in the [MembersData_Table]). At the same time, I want the entered
value to be saved in the [Spouses_Table]. (The [Spouses_subform] is in
continuous forms view because I made my Database for instances like having 2
or more spouses).Any help is very much appreciated.. thanks..

 

[Allen Browne]

A person can have multiple spouses? Perhaps this is historical or
geneological data.

Could the spouse also be a member in their own right? That sounds highly
likely for associations (couples with similar interests or qualifications)
or even for geneological data (where a person married a 2nd cousin.) If so,
it would make sense to me to put everyone (members and spouses) in one
table, and then use another table to indicate how all these people are
related. (This would also solve the problem of how you record one spouse
having been married to 2 members, as well as one member having 2 spouses.)

There's a sample database in this article:
People in households and companies - modelling human relationships
at:
http://allenbrowne.com/AppHuman.html
that lets you set up a very flexible set of relationships.

 

[Samurai]

It is actually similar to working on databse of companies with multiple
employees. We would enter the name and other necessary information about a
company. Then, we would have a subform where we can input the names of the
employees working in a said company... I actually have made something like
this, but i don't actually know how i did it... I will forward my database to
you and kindly give some comments about my work.. by the way, what is your
email address? thanks..

A person can have multiple spouses? Perhaps this is historical or
geneological data.

Could the spouse also be a member in their own right? That sounds highly
likely for associations (couples with similar interests or qualifications)
or even for geneological data (where a person married a 2nd cousin.) If so,
it would make sense to me to put everyone (members and spouses) in one
table, and then use another table to indicate how all these people are
related. (This would also solve the problem of how you record one spouse
having been married to 2 members, as well as one member having 2 spouses.)

There's a sample database in this article:
People in households and companies - modelling human relationships
at:
http://allenbrowne.com/AppHuman.html
that lets you set up a very flexible set of relationships.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

hi guys! I have 2 tables, [MembersData_Table] and [Spouses_Table].. I made
a
form based from the [MembersData_Table].. I created a relationship between
these two tables by relating the fields [Name](each table has a field
named
[Name]). Then, I made a subform based on the [Spouses_Table]...What I want
to
do is have a name entered in the [Name] field in the main form(so it will
come out in the [MembersData_Table]). At the same time, I want the entered
value to be saved in the [Spouses_Table]. (The [Spouses_subform] is in
continuous forms view because I made my Database for instances like having
2
or more spouses).Any help is very much appreciated.. thanks..

 

[Allen Browne]

Please don't send the database.
Instead, download the sample, and take whatever is useful into your own.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

It is actually similar to working on databse of companies with multiple
employees. We would enter the name and other necessary information about a
company. Then, we would have a subform where we can input the names of the
employees working in a said company... I actually have made something like
this, but i don't actually know how i did it... I will forward my database
to
you and kindly give some comments about my work.. by the way, what is your
email address? thanks..

A person can have multiple spouses? Perhaps this is historical or
geneological data.

Could the spouse also be a member in their own right? That sounds highly
likely for associations (couples with similar interests or
qualifications)
or even for geneological data (where a person married a 2nd cousin.) If
so,
it would make sense to me to put everyone (members and spouses) in one
table, and then use another table to indicate how all these people are
related. (This would also solve the problem of how you record one spouse
having been married to 2 members, as well as one member having 2
spouses.)

There's a sample database in this article:
People in households and companies - modelling human relationships
at:
http://allenbrowne.com/AppHuman.html
that lets you set up a very flexible set of relationships.

hi guys! I have 2 tables, [MembersData_Table] and [Spouses_Table].. I
made
a
form based from the [MembersData_Table].. I created a relationship
between
these two tables by relating the fields [Name](each table has a field
named
[Name]). Then, I made a subform based on the [Spouses_Table]...What I
want
to
do is have a name entered in the [Name] field in the main form(so it
will
come out in the [MembersData_Table]). At the same time, I want the
entered
value to be saved in the [Spouses_Table]. (The [Spouses_subform] is in
continuous forms view because I made my Database for instances like
having
2
or more spouses).Any help is very much appreciated.. thanks..

 

[Larry Linson]

... I will forward my database to you and kindly give
some comments about my work.. by the way, what is
your email address? thanks..

For good suggestions on effective use of newsgroups, see the FAQ at
http://www.mvps.org/access/netiquette.htm. Newsgroups are for users helping
users, not just a source of free consulting for individuals. It is helpful
to a lot more users when both the questions and answers are posted in the
newsgroups. That is why you do not find a valid e-mail address on or in many
of the posts here... such e-mail addresses are also often "harvested" by
spammers.

Except for an occasional answer by a Microsoft employee here (usually
clearly identified), all the answers are provided by volunteers. Some of
those volunteers, Allen being one, and I being another, have been recognized
for our contributions to the Microsoft software user community with the MVP
designation, but we are NOT employed by, nor paid by, Microsoft. For more
information on the MVP program, see .

Larry Linson
Microsoft Access MVP