InfoPath Dev

I have a table with managers and the vendor they supervise. What I would like to have happen is:

When a user selects a manager from a pulldown, the corresponding vendors will populate an existing blank table or repeating section. For example, I select Manager Bill Smith, the names of 4 vendors he is responsible for populate a column in multi-columned table. Ideally, I would toi display only a 1-row table and have it expand rows depending on the number of vendors linked to a manager, but will settle for a static table in necessary.

The number of vendors a manager is responsible varies.

Where is the data stored? i.e. where is the list of managers stored? Once selected, where does the form go to get the data for the vendors? Is this information stored in Active Directory? SQL? SharePoint?

At this moment, it is 4-column esxcel file that I incorporated as a resource file into the Infopath form

One you have the data added to the InfoPath form as a secondary data source, then it's just a matter of filtering. There are tutorials out there on filtering, such as this one, but my quick Google search didn't find one specific to your scenario. Hopefully a little more searching will turn up a useful tutorial. Good luck!

Perhaps, I am not explaining very well....I have a pulldown box which is bound to a data conncetion/XML file. It contains the names of supervisors and the vendors they are responsible for. If the vendor is responsible for more than one vendor, then there are separate rows for each relationship. What I hope to accomplish: When a user selects a supervisor from the pulldown box, a repeating table is populated with the corresponding vendors. If there are 3 vendors, then 3 rows in the repeating table will be created with the vendors name in the appropriate field.

At this moment, I CAN get the pulldown (supervisor) to populate only 1 vendor in the repeatig table. But not more than 1.

I have attached the xsn