Relate works; Join does not in FGD v10

Question

I have a feature class of streets and a table of street addresses. I would like to derive a point feature class from streets; I've added the centroid point x,y values to the street segements. On a certain class of streets ( free way fly overs) I have calculated the address = "2 " As mentioned, I have a table of the exact same addresses along with a name for the fly over. I can relate my table to the features via address, and when I select a table record > related tables I get the corresponding feature class selected. However, when I try to perform a join via the address field, the join does not validate and the procedure tells me no records found. All the attributes from the (non) joined feature attribute table are . The addresses are unique, so it's not like I'm trying to perform a one-to-many join and just getting the first join. I get nothing.... Can anyone shed some light on this for me?

JoeBorgione · Answer

Lance-  Today I'm on a 10.2.2 machine, and I did the same thing as yesterday.  Everything works here so I think it's not an issue.....

LanceShipman · Answer

Your best bet is to contact Technical Support. They have a standard procedure for downloading data.

JoeBorgione · Answer

Lance-  lo and behold...  A few years later and I've stumbled upon the problem again.  Using v10.0 SP5.  I was actually trying to troubleshoot another forum users' problem and this resurfaced.

Here is the scoop:

I have a point feature class with a text-type field to join to a text-type field in another table.  I initially set the table up such that it would support a 1:1 relationship and a subsequent join and it worked fine.  Here is a screen shot of the points table Joined via the JoinItem field to the datatable (which is shown in the lower portion of the table view window)

Then I altered the table such that it had multiple records, changing the relationship from 1(point) to Many(records in table).

No problem right?  I'll just use a summary to get a total for the attribute I want to label the points: so I Summarize on the common join-item in the stand alone table, getting the count of each instance of the join-item and a summary of the values:

But when I try to join the point feature class attribute table with the summary table, I can't:

If you want me to send the data, let me know where to....