Here is the solution I have so far with help from the list. I have one map layer called parcels and 2 db tables. I have a parcel map layer that contains a unique field [PIN] for its polygons. Next, I have a db table called taxtie with 2 fields in it [TaxID],[PIN]. Now I can join the parcel map layer to the taxtie table via the common [PIN] field. Once this join is made, I then have the [TaxID] that is common to my tax table [TaxID] which list every person who is taxed and assigns them a taxID number.
This will work but it requires me to run a query on the parcel layer and the taxtie layer, save that query to a map file, then run a query of the newly created map file and the tax table and then save that final query as a map. This process would have to be done everytime I wanted current db info. I think that there is a better way I just don't know how. Anyone have any ideas or suggestions? -----Original Message----- From: Michael Smith [mailto:[EMAIL PROTECTED] Sent: Wednesday, August 11, 2004 8:28 AM To: [EMAIL PROTECTED] Subject: 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: 12978
