Results 1 to 5 of 5
  1. #1
    haydn.lamb is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2016
    Posts
    2

    how to add information from a query form to a related table?

    How can I add to an existing table within a query form, i.e.?
    I have a Table for:
    “Main Client”


    “Site they are in charge of”
    “Site contact”
    When inputting a new job with a new Client, Site or Site contact (not in the existing table) at the moment I need to update the relevant table first, then use the combo box in the form to add the information to the database. Can this be done automatically via the combo box? I have tried setting “limit to list” to NO but this does not resolve the problem.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Make a query from the table with your data. It pulls ALL UNIQUE values from the column. Self updating.

  3. #3
    orange's Avatar
    orange is online now Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    haydn,

    Please tell us more about your application. What exactly is your business in plain English?
    Can you tell us more about your tables?

    I see things like Job, Client, Site and SiteContact. I'm not sure what a query form is?
    I hope Ranman has understood your situation, but I'm not following based on the info provided.

    In any event, good luck with your project.

  4. #4
    haydn.lamb is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jan 2016
    Posts
    2
    Thanks for your post

    I hope the below explains in a little more detail.

    I have a maintenance company.
    I have created a form to input information on each job.
    This form is linked to other table’s i.e.
    Client Name: tblcliant
    Site Address: tblsite
    Site Manger: tblSiteContact

    When data inputting a new job and clicking on the combo box (i.e. which site) it shows all the information inputted in the table(tblsite), I can then select which one I want. If the correct information is not their, I have to open the tblsite and input the data then go back to the form (refresh) then use the drop down list to select the correct site, I would like to be able to click the drop down list in the form, if the correct site is not there! add it in the same combo box and it will auto update tblsite ready if I have a job on this site again.

    Thanks for your help.

    Regards

    Haydn

  5. #5
    orange's Avatar
    orange is online now Moderator
    Windows 8 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    Haydn,

    To get your database to support your business, you start with a business description and the business rules. That is key to getting your tables and relationships set up to meet your business rules. Once you get a database design, based on your rules, you can test that design before ever getting to forms and/or queries etc.

    See this for an outline from Barry Williams' site.

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

Similar Threads

  1. Replies: 3
    Last Post: 05-02-2014, 09:02 AM
  2. Replies: 25
    Last Post: 03-19-2013, 10:08 PM
  3. Replies: 9
    Last Post: 07-06-2012, 11:33 AM
  4. Replies: 7
    Last Post: 07-02-2012, 10:50 PM
  5. Replies: 4
    Last Post: 01-03-2011, 10:54 PM

Tags for this Thread

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