T
Tom
Good after noon and thanks for your help
I have a database that keeps track of all properties I'm
doing a
title search, with the following tables.
tblProperty = each property can have multiple Mortgages
tblMortgage = each Mortgage can have multiple Assignments
tblAssigned = (Assigned means, one bank sold the mortgage
to another
bank)
tblSatisfaction
Any Mortgage, Assignment, Satisfaction, or CEMA gets
recorded with a new Book & page#
The next table is called
tblCema = (Cema means a mortgage was put in a new Cema
Mortgage,)
Most of the time, a Cema will be a combination of 2-3
mortgages, & gets a new Book & Page #
However, if a bank gave you 1 mortgage and latter on the
bank is adding more money without a new mortgage, it also
gets recorded in a cema with a new Book & Page #
Here is my problem
A Cema can also be assigned to another bank, and then can
be added to another Cema and then assigned again, and so
on and so on.
On the report, I must show all transactions occurring for
each record from beginning to end.
In other words, all transactions from the Cema and down
the road should be entered once; however this information
can be displayed for several mortgages.
If any one knows of a sample database with such an
example, can you please share it with me?
Please let me know if you need more clarifications on this
question.
A very big THANKS to every body's help
Tom
I have a database that keeps track of all properties I'm
doing a
title search, with the following tables.
tblProperty = each property can have multiple Mortgages
tblMortgage = each Mortgage can have multiple Assignments
tblAssigned = (Assigned means, one bank sold the mortgage
to another
bank)
tblSatisfaction
Any Mortgage, Assignment, Satisfaction, or CEMA gets
recorded with a new Book & page#
The next table is called
tblCema = (Cema means a mortgage was put in a new Cema
Mortgage,)
Most of the time, a Cema will be a combination of 2-3
mortgages, & gets a new Book & Page #
However, if a bank gave you 1 mortgage and latter on the
bank is adding more money without a new mortgage, it also
gets recorded in a cema with a new Book & Page #
Here is my problem
A Cema can also be assigned to another bank, and then can
be added to another Cema and then assigned again, and so
on and so on.
On the report, I must show all transactions occurring for
each record from beginning to end.
In other words, all transactions from the Cema and down
the road should be entered once; however this information
can be displayed for several mortgages.
If any one knows of a sample database with such an
example, can you please share it with me?
Please let me know if you need more clarifications on this
question.
A very big THANKS to every body's help
Tom