Re: help with many to many relationships

#1

With a many to many, you can handle the data entry for your junction table
like this:

Create a form that updates the junction table.

The field that updates the child can be replaced with a combo box that looks
up in the child table.

Change the form properties to have the form's default mode to be the list
mode. (looks like a table).

Now create a form that updates the parent. Drag the junction form onto the
parent form.

Presto.

You can now add children to the Parents by selecting from the dropdown.

"JE Madison" <jemadison_2000 (AT) yahoo (DOT) com> wrote

Quote:

I am building a database for a school. Most of my experience has been
with "one to many " relationships in databases. In this scenario each
student may have more than one parent, guardian and or relative. However
each parent, guardian or relative could have more than one student at
the school as well. This looks to me like a "Many to Many" type of
situation requiring a junction table. Is there any other way that this
should be approached? Or would a "many to many" be the right way? Also
how do I handle data entry forms for a "many to many"?

Thanks for any help
I can be reached at jemadison_2000 (AT) yahoo (DOT) com

#2

the junction form looks up in the child and stores the id in the junction
table.

"me" <XDXaXrXcXyX (AT) XSXiXtXeXwXaXrXeX (DOT) XcXoXmX> wrote

Quote:

With a many to many, you can handle the data entry for your junction table
like this:

Create a form that updates the junction table.

The field that updates the child can be replaced with a combo box that
looks
up in the child table.

Change the form properties to have the form's default mode to be the list
mode. (looks like a table).

Now create a form that updates the parent. Drag the junction form onto the
parent form.

Presto.

You can now add children to the Parents by selecting from the dropdown.

"JE Madison" <jemadison_2000 (AT) yahoo (DOT) com> wrote in message
news:3F430028.ABC5CD6A (AT) yahoo (DOT) com...
I am building a database for a school. Most of my experience has been
with "one to many " relationships in databases. In this scenario each
student may have more than one parent, guardian and or relative. However
each parent, guardian or relative could have more than one student at
the school as well. This looks to me like a "Many to Many" type of
situation requiring a junction table. Is there any other way that this
should be approached? Or would a "many to many" be the right way? Also
how do I handle data entry forms for a "many to many"?

Thanks for any help
I can be reached at jemadison_2000 (AT) yahoo (DOT) com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: help with many to many relationships

comp.database.ms-access comp.database.ms-access

Re: help with many to many relationships - 08-20-2003 , 04:52 PM

Re: help with many to many relationships - 08-20-2003 , 05:12 PM