N
Nicola Brennan
Hi
I am trying to create a database in Excel (yes, i know i should probably be
using Access, but unfortunately the firm i work with are too tight to
purchase it for everyone!) and trying to make it relational. The aim (i
think) is to have 3 databases, one for contact information (this would
include a list of clients, other Estate Agents and applicant details), one
to store a list of properties which are available, under offer, or let, in
our region and a third database to show job details (ie: what the job was,
how much, when started, when completed, who was in charge etc).
What i need to know is if it is possible to link each database and how do i
go about it. Each of the databases would have something in common with each
other i.e. the name of the Estate Agent dealing with a specific property
would be included on the property database and on the contact database. In
addition to this if our company was dealing with a specific property then a
job number would be allocated to the property and the job details and number
would reside on the Job database.
Do i need to give each individual record an ID (as in Access), or can i just
link via the Estate Agent's name or, in the case of the job database, via
the job number.
Any assistance would be most appreciated.
Many thanks
Nic
I am trying to create a database in Excel (yes, i know i should probably be
using Access, but unfortunately the firm i work with are too tight to
purchase it for everyone!) and trying to make it relational. The aim (i
think) is to have 3 databases, one for contact information (this would
include a list of clients, other Estate Agents and applicant details), one
to store a list of properties which are available, under offer, or let, in
our region and a third database to show job details (ie: what the job was,
how much, when started, when completed, who was in charge etc).
What i need to know is if it is possible to link each database and how do i
go about it. Each of the databases would have something in common with each
other i.e. the name of the Estate Agent dealing with a specific property
would be included on the property database and on the contact database. In
addition to this if our company was dealing with a specific property then a
job number would be allocated to the property and the job details and number
would reside on the Job database.
Do i need to give each individual record an ID (as in Access), or can i just
link via the Estate Agent's name or, in the case of the job database, via
the job number.
Any assistance would be most appreciated.
Many thanks
Nic