SQL Database Integration

Re: Master/Detail link to outside XML document

Patrick Halstead — Fri, 08 Jul 2005 06:27:55 GMT

There are ways to simulate Master Detail with a 2DS (Secondary Data Source) using OnContextChange event and using conditional visibility as Agni suggests. Either Greg has done this or it will pique his interest. I'll ask him.

Patrick Halstead [InfoPath MVP]
InfoPathDev

Re: Master/Detail link to outside XML document

lkropp — Fri, 08 Jul 2005 00:12:10 GMT

Thanks for the reply Agni. I was beginning to suspect that was going to be the answer.

The help files do mention doing this exact same thing between an XML document and a database like MSACCESS. It seems that they should make it work with other XML documents as well.

Larry Kropp M.D.

Re: Master/Detail link to outside XML document

Agni Jonnalagadda — Thu, 07 Jul 2005 07:49:24 GMT

Hi Larry Kropp,
Welcome to the Board!
I guess if they are two different xmldocuments, one of it is secondary dataconnections. Master/Detail does not work with a secondary dataconnections, it works only with primary dataconnections.
You can do conditional visibily, but this will be performance hit if you have more data.
Or you can write some code to show the details.

Agni
InfoPathDev India

Master/Detail link to outside XML document

lkropp — Wed, 06 Jul 2005 21:54:05 GMT

I'm so close, but I can't get this to work. Here's the setup.

1. One form has a table with 5 columns of client information.
2. On Another form the main form), I want to select the client's name, and then pull from the table in the remote document the other four fields....master/detail, but across xml documents.

I can't seem to get a master in one table to pull from a detail in table in another form....I thought Info path would do this.

Any help.

Larry Kropp M.D.