realty database

[Rick]

I need help adding to a basic realty database I have.

I have tables for tblClients, tblPhoneCalls, etc.

I have a form for my clients with tabs that contain basic info, dates, phone
calls, property info, etc. I was a bit short-sited when I built this and
need to make some fundamental changes, but am a bit lost.

Since these folks will hopefully be moving from time to time, I think I need
to keep their properties in a separate table. Then as they buy and sell, I
can move to properties. I believe I need to create a new table to store the
property info (tblProperties) and use the address as the key. I also think
I would need an additional table that contains the property key and the
current owner. Then my form would use this relationship to display the
appropriate property (or properties) for each client.

I would like to be able to pull up a property in a different form and see
the current owner and (in a continuous subform) all previous owners, the
dates sold, and pricing info.

Can you point me in the right direction?

Thanks in advance for all the help!

Rick