Connecting To a SharePoint List w/ Relative URL

[ts383]

I've got an InfoPath form with a drop down list that needs to be bound to a
SharePoint list that doesn't resides on the parent site of the site that
contains the Form Library the Infopath form publishes to.



Parent Site

--List

--SubSite

---Form Library w/ Infopath Form





The "parent" site is actual a programmatically created site that is itself a
child site of something else. The list in question gets created at the time
the "parent" site does (basically its an event-creation process. The list
gets populated with some options that are selected once, at creation time,
these selection will populate the drop down on the InfoPath site)



Because there can be multiple parent sites, the GUID for the master list
isn't the same, i.e



Root

--Company 1 (url: root/companyId)

--Event 1 (url: root/CompanyId/EventId)

--List

--SubSite (url: root/CompanyId/EventId/EventTypeId)

--Form Library

--Event 2

--List

--SubSite

--Form Library

--Company 2

--Event 1

--SubSite

--Form Library



How can I get the drop down list in the InfoPath form to read the correct
list? I gather I'm going to need to do some work in the Form_Loading event,
which is fine, but how can I specify a data connection for a control and bind
it in the forms loading event?



TIA