Relates only showing numeric fields?

Question

I asked this in the comments of another post, but it wasn't relevant, so I wanted to ask here.

I related a map layer to a standalone table and want to get a pop-up that includes data from both. This is working for the most part, but text data from the standalone table isn't popping up as an option, only numeric data. i.e. I can choose to display a Field that states '5', but not one that says 'ABC'. Has anyone had this happen before? Do you know why/how to get all of the fields to show, not just the numeric one?

This is what shows under the Relate in the Configure Pop-up Window:

And this is what the Standalone table looks like:

So yeah, only the numbers are options (except CNTY_FIPS, which is okay). Does anyone know why?

ChristopherCounsell · Accepted Answer

Some pop up elements will only support numeric values when working with related data.

This is because it will do a statistical aggregation e.g. count or sum, that doesn't work for other field types.

E.g. adding a chart or field attribute.

You can show related data using a related records element. It'll show a list of related data.

You can add an arcade element or text element with arcade expressions, and drill down into your related data using featuresets.

EmilyC · Accepted Answer

For those looking for what I did, instead of a join/relate, I ended up creating a Relationship Class as well as an intermediate 'Junction' table that had a column from both of the other layers. With this, I did a One-to-Many Relationship class between the Junction table and each of the original tables. To do this, I made sure to create a new .gdb to put all three of these layers in, so they could communicate with each other. Once this was done, the two original layers could talk to themselves seamlessly, and I was able to configure pop-ups on my map layer to include data from both. Also, as a caution, make sure the map layer you are editing is the one from the new .gdb (right click layer -> add to current map). Even if you copied this new file from the original map data, you still need to add the new data to the Contents pane and then configure that new layer.