Database help for Real Estate Database

[Guest]

I have to do a database for a real estate company. I am having problems, if
someone can help me I will really appreciate it. My email is
(e-mail address removed)
So far I have decided to create 4 tables. One for properties, one for
clients, one for realtors and one for the rentals. On clients the PK will be
the client's social, on realtors the realtors social will be the PK, and on
properties I dont know what to do. Each property only has one Identification
Number, but each property can have two or more clients related to it. So I do
not know how to link the property and rental tables with the client and
realtors table. Please any solutions?

 

[G. Vaught]

You create your property table using the Identification number as the
primary. The Clients table will also have some type of primary key. You
could use AutoNumber for this or create a key using parts of the clients
name with numbers. Then you will create another table that will use the
primary key from the properties table and add the primary key from the
clients table. Make both these fields the primary key and then create the
relationship between all three tables. Doing this will prevent you from
adding a client twice against the same property.

 

[Duane Hookom]

Erick already has a thread going with the same question in tablesdbdesign.
It would be better to keep all replies in a single thread.