In my scenario I have a Oracle database. I need to fetch data from a table and need to populate in a drop down list.And the other thing is I have a three tables which have one to many relationship and I need to cascade the drop down lists.
Its like this I have three tables as follows.
I have company table. Company has one or more Branches. One branch has one or many employees.
I have created a view in Info path. I created one drop down in it and it should consists name of companies. When user select one company second drop down should populate data only related to the the particular customer. When one branch is select the third drop down should populated the employees only for that branch.
Can anybody give an idea to implement this.
Thanks
Note: I am new to the Info path. I just started work on Info path.