Results 1 to 2 of 2
  1. #1
    selvamraja is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2012
    Posts
    1

    How to Auto Populate in combobox and save data in a new table

    Hi,
    I am a novice in programming but am trying my hand on MS Access 2007 to develop a small application for my office.




    In the first table I will create a Company Database collecting data such as Name, Address, Email.
    In the second table I will create a Inventor Database collecting date such as Inventor Name and Citizenship.
    In the third table I will create a Inventions Database collecting data such as Case ID, Invention Name, and invention date.


    Now I will be creating a form with the third table and add the first and second table as sub forms. Now I want the Company Name and Inventor Name to be populated as a drop down fields. Next to these files I would like to add a button that will add the entry into a new table called "Company Name and Inventor Name". The Case ID will be a common field used for parent and child forms. So the relationship type will be One to Many (One Case ID but Many Company Name and Many Inventor Name)


    The purpose is to reuse the company and inventor data. I am able to populate a drop down in the form using table lookup but I am unable to save it into another table. Also I read that it is better to use Form Lookup instead of Table lookup. Can anyone help me on how I create the form lookup?


    The end result is to generate a report that will show a unique Case ID that might have one or more company names under it and one or more Inventor Names under it.


    Appreciate your help - Thanks.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    A case can involve multiple companies and inventors?

    If company and inventor are paired (adversaries or partnership?), maybe need table like:

    tblCaseCompanyInventor
    CaseID (foreign key)
    CompanyID (foreign key)
    InventorID (foreign key)

    If company and inventor are independent of each other (all companies versus all inventors?), maybe two tables like:

    tblCaseCompany
    CaseID (foreign key)
    CompanyID (foreign key)

    tblCaseInventor
    CaseID (foreign key)
    InventorID (foreign key)

    Form setups depend on business/information flow. Could have a form bound to tblCaseCompanyInventor with comboboxes to select case, company, inventor. If entity not in table then have a form open to enter the new record 'on-the-fly'. Now new entity is available for selection from combobox. This could use the NotInList event of combobox.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 2
    Last Post: 08-22-2012, 07:59 AM
  2. Replies: 3
    Last Post: 07-26-2012, 03:55 PM
  3. Auto-populate from another table
    By Palladian1881 in forum Access
    Replies: 2
    Last Post: 08-16-2011, 11:29 AM
  4. Replies: 4
    Last Post: 08-15-2011, 10:06 AM
  5. Save Combobox results to Table
    By Kinder0177 in forum Access
    Replies: 5
    Last Post: 06-29-2011, 08:47 AM

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