Using the make query table tool

CameronCole1 — Wed, 24 Aug 2016 17:17:18 GMT

I am trying to join parcelpoints, a feature class, to permits.dbf, which is a table. They are both in the same GDB and the field they have in common is parcel ID. A "Join" works well, 1 parcel to 1 permit and it works many parcels with 1 permit. However, it doesn't work with 1 parcel with many permits. I was thinking of doing a Relate? Instead of a Join? I am not sure.

My overall goal is to get the parcel points feature class to have the information of the permits table. They have parcel ID as a common field. Then, while in the GDB I can "enable attachments" and connect PDF's to each parcel point due to the same name of the PDF's and the field Permit ID in my permits table. Then on AGOL I can symbolize the parcel points to "Permits" that are connected to the parcels.

I am trying to use the Make Query Table Tool because that's what the other blogs have said to do but I am having trouble getting the table I want.

To make it simple lets say I have a feature class and table where the table has an ID field and a permit number associated to it. Then the feature class has matching ID's with the table.

Re: Using the make query table tool

NeilAyres — Thu, 25 Aug 2016 10:14:16 GMT

Are you sure that you need a Make Query table tool here.

Wouldn't a simple join do what you need?

Re: Using the make query table tool

CameronCole1 — Thu, 25 Aug 2016 15:42:57 GMT

I have a scaled project, what I wasn't doing was exporting the matched features. So just based on the join it seemed that not all of the permits were coming through to the parcels. However, when I exported the join matches to a new feature it created new parcel features to allow the 1:M join.

topic Re: Using the make query table tool in Developers Questions

Using the make query table tool

Re: Using the make query table tool

Re: Using the make query table tool