difficulty with an order details subform

[Guest]

One of the tasks for the database I'm trying to build for a journal is to
handle orders from subscription agencies for their own clients. I accommodate
this by having one table for PrimaryClients related to another for
SecondaryClients. This now works fine for entering subclient details specific
to each primary client. But I'm having difficulty with configuring the way
orders are entered. An agency sometimes places a single order for all their
clients, sometimes separate orders for just for one or two at a time.

I've structured my orders and order details tables and form to try to handle
this.

My tblOrders has the following fields:

OrderID
OrderDate
PrimaryClientID

My tblOrderDetails has these fields:

OrderDetailsID
OrderID
SecondaryClientID
CatalogID
Quantity
Currency
UnitPrice, etc...

I have an Orders form with an OrderDetails subform, but the problem is that
on the subform I want a combo box which is filtered to display only those
subclients that are specific to the primary client selected in the Orders
form. I can't figure out how to tie the subform successfully to both the
OrdersID field and the PrimaryClientID field. My SecondaryClientID combo box
on the subform shows *all* subclients.

What's the best way to solve this?

 

[Guest]

There have been no takers for this question, so I'll drop it for the time
being. Will post again later with a revised question.