Re: New to Infopath... Can this be done???

Qazi Anis — Thu, 22 Apr 2010 13:39:16 GMT

i am not sure we can connect to excel with out code, infopath 07 supports access database. you can convert excel into access adn later on use it.

filtering data of a dropdown based on selection in some other dropdown is called cascadign drop downs. there are a lot of posts regarding that all over the site. check here

New to Infopath... Can this be done???

Stockbuster — Thu, 22 Apr 2010 09:25:48 GMT

Hi there.

I am all new to Infopath, and wanted to aks if what I want to do is at all possible to do in Infopath, before spending a ton of time trying to get it to work :-)

I want to generate a form, that automatically gets data from some excel sheets... To make it simple.

-----------------------------------------------------------

The Infopath form should consist of 3 drop down lists.

One list should be a list of rooms (lets call these room A, B, C, D and E)

The second list should be formated in a way to only show the items in the room the user has selected (exampel: in room A there is a dinnertable and 2 chairs, room B is empty), I was here thinking that Infopath could get the information about the inventory of each room, from different excel sheets (exampel excel sheet "roomA.xls" containing the before mentioned items, and "roomB.xls" being empty).

The last list should be the same rooms as in the first list....

------------------------------------------------------------

Purpose of the whole thing... By selecting "room A" in the first list, then selecting "dinnertable" in the second list, and finally selecting "room B" in the last list (and of course hitting the SUBMIT button... I want to be able to move the "dinnertable" from one excel sheet to the other.

Any one who has any good ideas, as to how I can do this... Much appreciate any help I can get.

Thanks!

Newbie Questions

Re: New to Infopath... Can this be done???

New to Infopath... Can this be done???