Results 1 to 4 of 4
  1. #1
    hansi is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2011
    Posts
    2

    load data to a drop down menu according to the another drop down of same form

    Hi


    I have 3 tables named COMPANY, CONTACTS & JOB. Each has fields as follows;
    COMPANY: cmpID,companyName, address
    CONTACTS: cntID,contactPerson,companyName(this is a foriegn key refer to COMPANY table)
    JOB: job,companyName, contactPerson(this is a foriegn key and refer to CONTACTS table)

    Company may have multiple contact person
    A job should have a one contact person and one company

    My problem is this; I have an form to enter job details. It has a dop down menu to select company neme. after selecting a company from there i wand to load relevent contact people from that company to load into next drop down menu in the forum.

    Could some one please help me in this.

    Thanks
    Hansi

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    I think that you are referring to cascading combo boxes. Here is how you would set them up.

    http://www.fontstuff.com/access/acctut10.htm

    Alan

  3. #3
    hansi is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Nov 2011
    Posts
    2
    Quote Originally Posted by alansidman View Post
    I think that you are referring to cascading combo boxes. Here is how you would set them up.

    http://www.fontstuff.com/access/acctut10.htm

    Alan
    Thanks for the guidence. But that doesnt address my problem. Because I cant assign company names and relevant contact persons by default. So there is no way to "case" checking. Users should have an oppertunity to enter company names and contact persons. so the described methods on given link cannot be used for the matter

  4. #4
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Your explanation in the first thread indicates a need for cascading combo boxes. If this is not the case the, perhaps, if you gave some examples of your data it might be clearer. Even better, post a copy of your database with sample data so that we can see exactly what you have and be sure to explain your expected results. I am confused by your last posting.

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

Similar Threads

  1. Choosing values of a field with drop-down menu.
    By kikonas in forum Database Design
    Replies: 4
    Last Post: 10-27-2011, 08:12 AM
  2. Select Drop down menu in Report
    By desiree in forum Reports
    Replies: 5
    Last Post: 09-06-2011, 09:51 AM
  3. Drop Down Menu Parameters
    By spoonman in forum Programming
    Replies: 5
    Last Post: 08-18-2011, 02:16 PM
  4. Replies: 5
    Last Post: 08-11-2010, 09:16 AM
  5. How about creating a drop down menu in a report?
    By beastmaster in forum Access
    Replies: 2
    Last Post: 12-29-2005, 01:01 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