I am running into a strange issue when I try to join multiple tables to a single base table. I have 4 tables, all related to each other through a unique string column. Table A is my "base" table. I want to add joins for tables, B, C, and D to table A, and publish to AGOL. I don't want to permanently join, just use the add join dialog. There are a lot of similarly named fields in the tables, but also a good bit of different information. And these are 1 to many or none relationships.
I can usually add two tables as joins (e.g. add joins for B and C to A, or D and B to A, etc.). However, when I try to add the final join, Pro throws an error
arcgisscripting.ExecuteError: ERROR 001486: Cannot use fields from joined tables.
Failed to execute (AddJoin).
I really don't know what to make of this. Anyone have experience or insight here?