Auto Numbering

  • Thread starter Thread starter Nicola Brennan
  • Start date Start date
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
 
Excel provides no specific support for relational databases. You could use
the Vlookup worksheet formula or the combination of Index and match to
retrieve records from the 3 sources into a common area.


If you are only reading from the database, I believe you can read from an
access database file without having access installed if you have the access
ODBC driver installed. You can use Data=>Get External Data and have MSQuery
link the data.
 
Back
Top