I have a situation where I have a Model driven App that connects to our ERP data.
I have set up Dataflows that map to tables within my application that are Periodically updated with the ERP Data (ie Live-ish data). The only way to change the data is through the ERP and passes the updates through the dataflow. The dataflows are then mapped to MDA tables for use. The question is some of the linking that goes along with its use. I would like to have my connector table that uses the Project number that fully brings the project data into the application for viewing.
DF(s) = > mapped Solution tables
- Header Project (Project # is Key Field)
- Child Financials (Project is Key reference Field) 1;N
- Sub-Child WBS (Project Is Key Reference Field) 1;N
Where I am having a problem is the connection, I can easily connect to the header file. The problems are the child references of the periodically updated external data. How could I do the single selection of the Project number so the lower levels automatically connect to the children table items.
- Linking Table connects to Header Project (Project # is the Key Field)
- Child Financials (Project# is Key reference Field) 1;N
- Sub-Child WBS (Project# Is Key Reference Field) 1;N
Any guidance or ideas would be helpful
