Auto Numbering
 

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

Auto Numbering
 

See one possible answer to your multipost of this question.

--
Regards,
Tom Ogilvy

Nicola Brennan wrote in message
...
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