invoice form

[musicalogist]

I am somewhat new to access, and I'm having trouble with something. I'll try to explain it.

I have two tables, one named "clients" and one named "accounts". These two tables are linked by the client# and account# on a many-to-many relationship. So each new accountcan have more than one client associated with it, and each client can be part of different acounts. There is a junction table between the two, where each account/client is stored



Then I have a table named Invoice, and a form to input data into that table. For each new invoice I add, I specify the account number and client. This is what I want to do:

When I want to add a new invoice, I specify the account number via text box. Then I want to specify the client via a combo box THAT ONLY SHOWS THE CLIENTS THAT ARE ASSOCIATED WITH THE ACCOUNT NUMBER I JUST WROTE.

If anyone can help me it would be great, cause I'm really stuck. I don't know if I explained it correctly. I appreciate any help!

[pbaldy]

Sounds like a cascading combo type issue:

http://www.baldyweb.com/CascadingCombo.htm

[musicalogist]

thank you, i'll look into it!

[pbaldy]

No problem, post back if you get stuck. Welcome to the site by the way!