Duplicating DB

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hello All. I have set up tables, forms and Queries for a mortgage database.
I have designed this for a single applicant. If the mortgage is a Joint
application then ALL the same details will be required for the second
applicant. Is there any way I can copy the tables, forms and queryies that
I have created for the single applicant?
 
Hi Chris

not knowning your table structure and a whole lot of variables (which i
would need to know if i was "building" this type of db) but if i had a
mortgage database (off the cuff) i would structure it somewhat like this

TBL_Application
ApplicationNumber - PrimaryKey - Autonumber
ApplicationDate - Date/Time field
anything else that is to do with the application itself (whether its a
joint application / the amount asked / the amount given etc etc)

TBL_Applicant
ApplicantID - PrimaryKey - Autonumber
Firstname
Lastname
and anything else that i wanted to know about the applicant (DOB etc)

TBL_MortgageApplication
MortgageApplicationID - PrimaryKey - Autonumber
ApplicationNumber - Long Integer
ApplicantID
and anything else that i wanted to know about the applicant in relation
to the mortgage application

then if it was a joint application i would have two ApplicantID entries
against the TBL_MortgageApplication.ApplicationNumber, if it was a single
application i would have only one.

Hope this helps, somewhat. Please post back if you'ld like further
information on the above.

Regards
JulieD
 
Back
Top