Relationships

[Dwight]

I need help with my relationships and form structures. Attached is a sample database for illustrative purposes.

Here are the rules I am trying to follow:

One client can have many banks.
One client can have many bank accounts.
One bank can have many bank representatives.
One bank representative can work for only one bank.
One client can have many bank representatives.

Are my relationships correct?

I need a form/subform structure where I can select a client and then select their bank(s) and input their bank account number(s). Then I need to be able to select their bank representative(s) - - this list should contain only bank representatives related to the currently selected bank.

A working form/subform example would be excellent, if at all possible.

I have worked with this for a few frustrating days.....I'm not sure if I am approaching it completely wrong or missing something small.

Any help is appreciated.

Thank you in advance,

Dwight

 

[RuralGuy]

Hi Dwight,
It looks like you are on the right track. I recommend breaking down the problem into smaller pieces. Start making forms that will do each part of your requirements until you have forms that will do all of the parts correctly. You could just open each form in succession as it is needed. Then you can see if you can put these forms together on a larger form as SubForms, maybe using a tab control on the main form if needed.