Hope you can help me. I'm new to Crystal Reports and the CR manual I have doesn't help too much.

I'm building a vb6 application where the user writes the name of a restaurant in a TextBox and use a CommandButton to create a report with the data for that restaurant.

I have the data for restaurants in two Access tables:
- The first table includes a unique record for each restaurant with general data like name, address, phone number...
- The second table includes several records for each restaurant, being each record a table reservation for a restaurant (client name, table number, date...)

I want the report to show the general data for the restaurant and a grid with all the table reservation data for this restaurant. And if necessary, depending on the number of table reservations, the report will need 2 pages.

As far as I 've seen till now it's not that difficult to show general data for a restaurant, but i have no idea on how to show in my report the other information too.

Any help will be welcome.
Thanks in advance.

By the way, I'm using CR9.