Quering a database via an InfoPath form

[gsn9877]

I have an infopath form that we use to submit data to an access database.
The same form is also set up to query the database. The database contains
details on reservations for specific departments, and there can be multiple
reservations for a single department. When doing a query, if there are
multiple reservations for the given department, how can I have all applicable
reservations show when data is returned?

 

[Paresh]

I have an infopath form that we use to submit data to an access database.
The same form is also set up to query the database. The database contains
details on reservations for specific departments, and there can be multiple
reservations for a single department. When doing a query, if there are
multiple reservations for the given department, how can I have all applicable
reservations show when data is returned?

You can use a control like repeating table to show multiple
reservations for a single department.

Thanks,
Paresh

 

[gsn9877]

Because I'm just learning InfoPath, could you provide more specific
instructions?