I have datasets with one to many relationships to tables.
These identical datasets and tables are in geodatabases by year.
I'd like to merge the years as the schema is the same every year.
However, I see if I merge them, the object ID changes and this is the only link I have to one of the tables REl_OBJECTID.
The table shows photos uploaded.
Is there any other way I can merge them, or will I just leave them separate for each year?