Best way to keep a AGO join updated

dougbrowning

I have a simple one to many join between a AGO table and a HFS.  Works great but it is static.  I would like it to update as new data gets added to the table automatically.

The rerun analysis button helps a little but it is a manual step to click.  Plus the real pain is when you rerun it you must create a new layer - you cannot just replace the layer so you end up with v2, v3, etc. Then I also have to go in and set the security on the new layer also.   I really wish it would just overwrite.

So is there a way to do relate instead, or have it update on a regular interval, or any other ways?  Again all I want is the field level join between the table and HFS to stay up to date.  

Thanks

dougbrowning

After a lot of research I found out you have to create a relationship class in the geodatabase before you publish the service to AGO.  Once it is in AGO there is no way to do it.  I tested and it works. 

Bummer for me since my service is out there and has new data already but may help someone.

Is there a way to have a Join_Count field like in ArcMap?