Help!!!
I am trying to match two databases. I am trying to create a database of
real estate clients to match the price database. For example: I have
clients A, B, C, D, C, E, F, G, H, I, J, K interested in properties that
range between $1,500 - $2,500. I would like to create a database that
automatically match the clients with the properties and/or indicate what
clients match the property prices. Help, please!!!
You're not looking for a *database* - you're looking for a *query*.
Short jargon lesson: In Access, a "Database" is a container, a .mdb or
.mde file containing multiple Tables, Forms, Reports, Queries and
other objects. A Table is where you store information; for example you
would have a table of Clients, and a table of Properties, and probably
other tables. A Query is what you would use to link two tables.
Here's a possible design: construct two tables, Properties and
Clients:
Properties
PropertyID <autonumber, Primary Key>
Address Text <e.g. 123 Maple Blvd.>
City Text <e.g. Scranton>
Description Memo
Price Currency
<any other fields to describe the property itself>
Clients
ClientID Autonumber Primary Key <don't use the name as key>
LastName Text
FirstName Text
<contact information, e.g. phone>
PriceRangeLow Currency
PriceRangeHigh Currency
Fill these two tables with your properties and the client information.
To find which properties are within each client's price range
construct a new Query in the queries window; add the Properties and
Clients table and select whatever fields you want to see. On the
Criteria line under the Price field in Properties put
= [Clients].[PriceRangeLow] AND <= [Clients].[PriceRangeHigh]
And... if you've got real estate going for $1,500 to $2,500 let me
know where!!!
John W. Vinson[MVP]
