Working with the same main value (ClientID) thru different forms

[Mishanya]

I have a folowing DB:
tblClients (ClientID and general info)
tblBanks (BankID and BankName)
tblBranchs (BranchID and general info)
tblAccounts (AccountID and deposits, stocks and other holdings)

Every branch may have multiple accounts (of the same or different clients);
every bank may have multiple branches; every client may have multiple
accounts.
I.e, the relationships are:
Bank-Branch, Branch-Account, Client-Account as one-to many;
Client-Bank, Client-Branch as many-to many (thru the account)

The main form has a cboClientName and shows a table with some data, related
to the chosen client. In the same form I want to put a few buttons wich will
open other forms:

1) frmClientGeneralDetails (based on the tblClients) - I want it to open
directly with the data of the client, choosen in the main form;
2) frmClientAccounts - with the records of accounts (number, sum of deposits
etc') and cboBank and cboBranch limited to the same client from the main form
(i.e. it opens blank with only the chosen client name as a caption, then I
can choose from the cboBank only banks, where he has accounts, then only
branchs of the chosen bank, where he has accounts). The output will be
record/s of the client' account/s in the chosen branch.

I know how to filter ComboBox options based on the other Combobox value, but
here the task is more difficult: I have to filter accounts and branches not
only by the "father" ComboBox, but also limited to the CientID.

I'll be happy to have some help on those two.

 

[Mishanya]

Please regard this thread as cancelled