So I am building an ArcGIS relational geodatabase; one copy is stored online for users to enter data into and another copy is stored locally for minor processing and then to generate reports. The geodatabase consists of a point feature class that is has a 1:M relationship with a polygon feature class; which then has a 1:1 relationship with a table. I built a model to add new data from the online version onto the local copy (which has to be done weekly) using the Append tool. However, the Global ID field/primary key for each component of the geodatabase is changed during the append process but the foreign key remains the same. So the relationships are now messed up and I can't get the data I need out of the database.
Is there another tool I should be using? Or maybe I need to make a text field and copy the GlobalID before doing the append, and then either copy the correct GlobalID back into the GlobalID field OR restructure the relationship so it's referring to the right field?