New to Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please could someone help with what must seem three very easy questions.
I work for a Mortgage Advisor and wish to create a database that will show
the following.
Client details, ie name and address ( this would obviously be unique but
there could be up to four clients on the same application)
I then need to create the clients mortgage details, ie property address ( we
could have one client buying two properties or more)

I have created a form with two tabs, one for the cleint details and the
other for the property details but have noticed when i search for the client
and then switch over to the property details it shows all properties for all
clients, how can I isolate this to be just the property for that unique
client? and also that it will show the other properties that that client may
also be involved with?

I also have on the client details Date of Birth, I want to be able to
automatically populate another field with Age. This would have to always take
todays date and subtract his/her date of birth and then populate that field
with age in years. Is this possible?
 
Age calculation is one of the most often asked questions. Here's one (very
good) answer:

http://www.mvps.org/access/datetime/date0001.htm

The relationships of clients to mortgages in your database is many-to-many,
that is one client can have many mortgages and one mortgage can have many
clients. To do that in a relational database you need 3 tables, the 2
obvious ones, and a third join taible that has at least 2 fields, one for
the MortgageID, and one for the ClientID.

Use a subform in 1 or both of the 2 main forms to enter the ID value using a
combo box to pick the data from the other table. There's a bit more
information here:

http://www.ehow.com/how_13626_define-many-many.html
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Back
Top