What do I use to display multiple categories at a single point? Join or Relate?

StewartGalloway — Fri, 10 Mar 2017 20:02:35 GMT

What do I use to display multiple categories at a single point? Join or Relate? There are multiple building locations and each have multiple cost categories (electric, gas, trash, etc.). I have a point file for the buildings and I have a table with costs. Is this a one-to-many relationship (bldg.-to-costs)? How do I Join or Relate these? They also need to be labelled (I think this may be the critical point that decides which I use since it is difficult to label features with a Relate?)

Re: What do I use to display multiple categories at a single point? Join or Relate?

JayantaPoddar — Fri, 10 Mar 2017 20:59:55 GMT

For one-to-many, it would be a relationship class or a relate. For a comparison among Relationship Class, Relate and Join, see Deciding between relationship classes, relates, and joins—Help | ArcGIS for Desktop

There is no out-of-the-box functionality to label related table, but you could achieve it using Python.

How To: Label a related table

topic Re: What do I use to display multiple categories at a single point? Join or Relate? in Data Management Questions

What do I use to display multiple categories at a single point? Join or Relate?

Re: What do I use to display multiple categories at a single point? Join or Relate?