Hi.



Maybe what I'm trying is impossible, but Access should be able to do it because the idea is pretty simple:

I have several clients, so there's a table called "Clients" which contains data for each one.

And I have a lot of orders, so there's a table called "Orders" which contains data for every order.

Each client has some orders.

What I want is a form where the customer's data appears at the top and below, in a number of tabs, the orders assigned to the client.

A sketch:


So there are as many tabs as orders from the same client, and the tab shows data for one order.

Does anybody know how to do something like this?