I need some help. I tried to look for help online for two days and I could not replicate the solutions found online. I would like to create an info path form with 2 fields. One filed "Country:" and one field "Cities:"
Database on a SharePoint list looks like this table:
3 columns (Country, Japan, Spain).
First row: Japan, Tokyo, Madrid.
Second row: Spain, Okinawa, Barcelona.
I would like a form with drop down for Country: (user can select Japan or Spain), If Japan is selected, then the second field "Cities" should have:
☐ Tokyo
☐ Okinawa
At which point the user can select using a "checkbox" either city or both. If Spain is selected, same thing would happen, the cities in Spain appear and the users can select one or both cities and submit.