I have a set of quite large SQL Server database tables that contain the required foreign keys to form a many to many relationship. I'd like to create an ArcGIS relationship on those tables but it appears the TableToRelationshipClass tool actually creates a new intermediate table by copying the data. Of course this means any updates by my app are not included in the relationship (unless I modify the app).
Is there any way to create a many to many relationship on the existing tables?