Design ?: Sql tables w/ sql subtables ok?

[Mercy]

Hi People,

I am having trouble creating a functionality.

I have a table of Clients and their cooresponding Orders.
Orders is a subtable w/ fields: Vendors, Product, Qty.
Orders and Clients are connected by a value: ClientName

I need to create an Order Form that will combine all the
Orders of the Clients into one form for each Vendor AND
still provide the details. (Provided that the Client's
Order hasn't ALREADY BEEN MARKED... marked means that a
Order Form has already been generated for that record.)

Ex:
Client A
Nike Shoes 10
Nike Pants 5
Unmarked

Client B
Nike Shoes 2
Reebok Hat 1
Unmarked

I need to create an Order Form that will look like

OrderFormNumber: 1
Vendor: Nike
Shoes: 2
Client A: 10
Client B: 2
Pants: 5
Client A: 5

OrderFormNumber: 2
Vendor: Reebok
Hat: 1
Client B: 1

I have a Qry: OrderDetails, which returns ALL the Orders,
it looks something like this:
Select Vendor, Product, Qty
From ClientOrders
Where ClientOrders.Marked = False

I have a Qry: OrderSummary, which looks something like
this:
Select Vendor, Product, Sum(Qty)
From OrderDetails
Order By Vendor

My question is... Can I make OrderSummary the Main
table ... and OrderDetails a subTable of it? Even though
OrderSummary is based off of it.

My most important question is ... does anyone have ANY
IDEA how I can "mark" the Clients' Order when I'm done
generating the Order Form?

I have thought of doing it through a recordset. But I
plan to eventually move to a sql server... which means
ADO ... and I heard that ADO can't change data through a
recordset.

Thanks for any feedback!
Mercy