I need some sugestions on to the BEST PRACTICES for filling this scenario:
I will have a SharePoint site and, using InfoPath, I will need to have access to three different forms for every user. One is person form, one is project form and one is organization team form.
Each person may (or may not, depending on their accesses) add or change data for each of the individual forms. Each form will have it's own underlying data table and support tables as required. I wanted to have the forms on a single page to the user, with tab controls to move across the forms for each category, and record navigation buttons to move down through the records of each form. Here is the quandry:
Should I do it in one InfoPath form with different views for each different table? then the data sources for the single form gets a bit hairy....
or
Should I have separate forms for each table, and then have the tab object be 'outside' the infopath forms....
Or
Is there a way I can open forms within a single form in InfoPath (similar to subforms in MS Access?
What is the 'recommended path' and the general 'best practice'?