Multiple tables/parents

[AFalcon]

Hi Everyone:

I have 3 tables (Projects, Employees, AssignedProjects)

The AssignedProjects table can have multiple entries for Project and
Employees. Now I was able to create a master/detail relationship without a
problem. The InfoPath form is able to enter data into the Projects table and
the Assigned Projects table. Now, I need the form to enter data into the
Employees table. Unfortunately, I only have a secondary connection available
for query purposes. And my main connection has two tables (Projects and
AssignedProjects)

How can I build the form so that I can enter data into the Employees table
as well. If I can't build this functionality in one form, can I call a second
InfoPath form from my first form?

Thanks in advance,

Alex

 

[Adam Harding]

AFalcon to answer your points in order

1. The only way to update a database is if you have it as a main connection
unless you use a web service to push the data from the form into the
database. Ie your employee fields do not go directly into a database but via
a web service to allow updating of the secondary data source.

2. Otherwise using rules-open a new form to fill out allows the
functionality to open up a new form.

Hope this helps

Adam