"Self Join" in an InfoPath form - InfoPath Dev
in

InfoPath Dev

"Self Join" in an InfoPath form

Last post 11-24-2012 10:07 AM by Patrick Halstead. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 11-23-2012 11:13 AM

    "Self Join" in an InfoPath form

    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".
  • 11-24-2012 10:07 AM In reply to

    Re: "Self Join" in an InfoPath form

    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.

    Patrick Halstead
    Project Manager at Qdabra
Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.