Results 1 to 4 of 4
  1. #1
    mooserider2 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    2

    Adding data to multiple tables with subforms

    Hey guys I am new to access but I am familiar with SQL databases. I have two tables: one for project data and another for project leader data. These tables are linked by a third table that relates projectIDs to leaderIDs. I am currently working on making a form that will go through each project and display the people involved in each project in a subform. I pulling the data from the the leader table that matches the the projectID with a query.

    I would like to be able to update the information in this subform directly (which I can currently do) and be able to add new project leaders to a project. What is the best way to add the new leader to this? If a person is already in the database how do I add them with the form without re-adding new information to the table?

    Thanks!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Maybe select from a combobox?

    Options for data entry.

    1. one form bound to junction table with comboboxes to select project and people

    2. main form bound to projects table and subform bound to junction table with combobox to select people

    3. main form bound to people table and subform bound to junction table with combobox to select project
    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.

  3. #3
    mooserider2 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    2
    Thank you, I was just working on a solution that sounds like it is your number 2 option. I just ran into an issue though.

    I have a query in ROWSOURCE of the combobox that takes the name and the ID of each person. Now I want to add a button to add the ID of the selected person into an INSERT query. How to I reference the ID of the selected person in the combobox?

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Why do you need INSERT query?

    If forms are bound to tables, and controls bound to fields, selected/entered data will pass directly to record.
    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. Multiple Subforms with Related Data
    By funkymuppet in forum Forms
    Replies: 1
    Last Post: 04-01-2014, 08:40 PM
  2. Replies: 6
    Last Post: 06-26-2013, 08:14 AM
  3. Replies: 10
    Last Post: 05-29-2013, 11:39 AM
  4. Replies: 10
    Last Post: 09-26-2011, 08:41 PM
  5. Replies: 3
    Last Post: 03-16-2011, 12:44 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