I'm developing an app which requires access to corporate data (currently stored in SAP), as well as app-specific data.
I created a solution named SAP Data, and a number of tables within the solution, to store the corporate data. These tables are the parent tables for two of the app-specific tables. The child tables were created in the app's solution, and have 1:N relationships via Lookup columns.
I found that, when I created the child tables, the parent tables from SAP Data were automatically added to the app's solution.
Now, when I export SAP Data, and try to import the solution into another environment, I get the error message "Import failed due to missing dependencies for SAP Data". If I import the app's solution first, it works fine.
It looks like that the parent tables have dependencies on the child tables, which seems to be the wrong way round. Is there a way to fix this (and avoid it happening in future)?
Thanks.
