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!