Hi Michael! The problem is common, but I do not know what kind of data you have access to, however will try to suggest a solution.
The core dilemma is that your parcel ID is not truly unique, in that two or more tax accounts can reference the same parcel. I do not know the cadaster system in your country, but here in Sweden, each parcel has a unique reference number in our national cadaster. Call it the 'birth-number'. Using that as the identifier in the parcel layer, it is perfectly simple to create another table (perhaps externally referenced) of property owners. These can of course own several parcels, or share ownership of the same parcel. The 'birth-number' is used as parcel identifier in this table. Then you simply join the parcel layer to the property owner layer, using the parcel ID as link and you will get a representation of the possible one to many relation between the two tables. In this way, the parcel table can be used as a core table to link all kinds of other tables with information related to real estate. So I suggest that you try and find some other id to use in your parcel layer, and separate the parcel table from the table containing the tax accounts. Duplicating the parcels is definitely the wrong way to go. Hälsning/ Best regards Mats.E ________________________ FB Engineering AB Södra Förstadsgatan 26 211 43 Malmö Tel: 040-665 64 80 Mobil: 0705-27 60 27 Fax: 040-665 69 90 e-post: [EMAIL PROTECTED] http://www.fbe.se "Michael Smith" <[EMAIL PROTECTED]> 2004-08-11 15:27 Till <[EMAIL PROTECTED]> Kopia Ärende MI-L multiple owners for one parcel Hi List, I was wondering how if some of you have a resolution to handling multiple owners for one parcel. I have a parcel layer with a single db field using the Tax ID Number from the County Tax Assesor's office that I use to tie to our county tax database based on these Tax ID Numbers. The problem I run into is that if I tie my parcel to a Tax ID number, there can be multiple accounts associated with a single parcel because of multiple owners of a single parcel. As a fix, I have added multiple parcels (to represent each owner i.e. tax id number) on top of one another and entered in the tax id number for each one for each of these parcels. I just was curious as to how any of you may handle this or if it is a problem that you have encountered. I am not sure if I have made myself clear in the question I am asking so feel free to ask for an example. Any suggestions are welcome. Thanks in advance. --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12922 --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] Message number: 12923