Tom,
Sheik, seemed to be new at access. So I suggested an easy work around. The suggestion you made would also work. He could then create a sub-form within his database to display these listed properties.
I have done the same thing with access. I simply set the phone number field to be a key item. This way you make sure that there are dup. entries. If you need help email me.
good solution, but what if a person (with the same phone number) has multiple properties listed? By using the phone number as the key, you will be prevented from entering in differnt properties that have the same phone numbers. Granted, the majoriy of the properties listed are the only ones listed by the individual owners. Another way (a little more involved) is to make an update query based on the phone numbers. This will group the records by the phone number and alow to decide if you want to delete the record or not. Just a suggestion.