Re: "Self Join" in an InfoPath form

Patrick Halstead — Sat, 24 Nov 2012 18:07:20 GMT

Hi Shrout1,

I'm assuming your repeating table would have two ID fields. One will get auto-generated when the row is inserted. You can use qRules GuidGen feature for that. GUIDs are better than row IDs since they will migrate across systems as your data moves. Then, define a second field called "Manager" which gets the ID for the manager row. You can select the manager row using a simple xpath filter, something like: my:EmployeeRepeatingGroup[my:EmployeeID = my:ManagerID].

Should be easy. We do this kind of thing all the time.

"Self Join" in an InfoPath form

Shrout1 — Fri, 23 Nov 2012 19:13:10 GMT

Here is a very good example (using MS Access): http://allenbrowne.com/ser-06.html I would like to create a repeating section that references itself; like an "Employee" repeating section that allows selection of other employees as a "Manager".

General

Re: "Self Join" in an InfoPath form

"Self Join" in an InfoPath form