Is there a way to create an Infopath form that displays rows of data in a SharePoint List based on a value entered? For example, the Sharepoint List has 900-1000 rows of data for multiple locations. The criteria will be State and City. If Miami currently has 50 rows of data in the list, then the user will select Florida and Miami from two drop downs then the 50 rows of data will show up in the form.
The user will then be able to change the current data, delete any rows, or add new ones. Is this possible?