Your advice for Many to many relain..

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

I have a database that keeps track for all properties I'm
doing a
title search with the folowing tables.

I have a database that keeps track for all properties I'm
doing a
title search, with the following tables.

tblMortgage tblMortgageSatisfaction tblSatisfication

Fields for tblMortgage
MortgageID - MortgageName - MortgageDate

Fields for tblSatisfication
SatisficationID - SatisficationName - SatisficationDate

Fields for tblMortgageSatisfaction
MortgageSatisfactionId - MortgageID - SatisficationID


The table tblMortgageSatisfaction will resolve the many to
many
relationship between tblMortgage and tblSatisfication.

When manually entering the information into the tables, it
seems to
be working fine. However, I really need help on creating
the data
entry form for the Satisfactions.
(Like how to enter the second mortgage for the
satisfaction #1)

If any one knows of a sample database with such an
example, can you
please share it with me?
I didn't find any example when searching.

Thanks in advance
 
Dear Tom:

Perhaps this is the kind of information you are looking for. I'll
start very generally.

At one point you say:

(Like how to enter the second mortgage for the satisfaction #1)

This leads me to expect you would want a construction that first shows
all the "Satisfaction" rows. This could be a single form showing each
Satisfaction one at a time, or a continuous subfrom showing all of
them at once (subject to scrolling).

Then, underneath that (or in any other relative position you desire)
you could have a continuous subform of all the Mortgages that have
that Satisfaction associated. This subform would apparently have just
one column, the MortgageName, as a combo box. In the row for new
records, the user could select a new MortgageName to add to the
currently selected Satisfaction. User's could also select a Mortgage
and delete it.

For this to work well, MortgageName would have to be unique in
tblMortgage. Otherwise, when the combo box lists all MortgateNames,
there could be two identical selections. How would a user ever tell
them apart? Yet they would be separate entities in the database.

I'll stop now and see if we're at all on the right track here. Please
fill in details if I've missed your intention or elements of your
design.

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts
 
Back
Top