I just figured out what the issue was. The relationship was looking for a DBID Alias which can be found at the bottom of the settings for a table then Advanced Settings.
Table alias _DBID_ROLL_UPS
I had changed the names of both tables so when I moved the tables into the new app, it changed the alias of the tables to the new name. I went back to the development app, changed the tables names back and then followed your process and it looks like it's working. I need to give it a good look to make sure everything works since there are a ton of calculations but I think that may have worked. Thanks for the suggestion.
