I have serverals problems to create a dynamic form with InfoPath. Here is how my Sharepoint lists looks like :
Places Table :
City | Adress | Phone number | ...
Ressources Tables :
City | Ressources Type | Capacity | ...
The column "City" of the Ressources Table get its choice from the "City" column of the Places Table.
First problem : When I create a listbox which get its data from the column City of the Ressources Table, I get only numbers as choices in the listbox, corresponding to the Id of each City I suppose... How can I get the name of the city from this table ?
Second problem : I have a second Listbox to choose the kind of ressource, and it depends on the chosen city. How can I populate this second Listbox dynamically when I change the city in the first listbox ?
Thank you with advance and sorry for my poor English.