Results 1 to 4 of 4
  1. #1
    musicalogist is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2010
    Posts
    10

    invoice form

    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!

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Sounds like a cascading combo type issue:

    http://www.baldyweb.com/CascadingCombo.htm
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    musicalogist is offline Novice
    Windows XP Access 2007
    Join Date
    Apr 2010
    Posts
    10
    thank you, i'll look into it!

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    No problem, post back if you get stuck. Welcome to the site by the way!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Invoice number
    By slik_02 in forum Access
    Replies: 3
    Last Post: 08-08-2009, 08:05 AM
  2. Invoice
    By billyff in forum Access
    Replies: 3
    Last Post: 04-25-2009, 12:15 PM
  3. Invoice Number
    By rzwoo in forum Access
    Replies: 0
    Last Post: 02-25-2009, 01:30 AM
  4. Replies: 3
    Last Post: 02-13-2008, 09:55 AM
  5. Duplicating lines in an invoice report
    By GordonEdinburgh in forum Forms
    Replies: 0
    Last Post: 04-21-2007, 12:20 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums