Results 1 to 2 of 2
  1. #1
    kgbo is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2013
    Posts
    10

    Question Form Setup Help

    Hello,



    I have created multiple tables: Employee, Error, Cause, Severity, and Action). Each of these tables contain different data.
    Is it possible to create a form that an individual can select data from these different tables thus once selected, it will take what was chosen and populate a master table where each line in the master table is one form entry.

    Thank you.

  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,624
    Use a form with comboboxes. Each combobox will have a RowSource that pulls values from one of the tables. Bind the form to 'master' table. Bind the comboboxes to fields of 'master' table. This is basic Access functionality and Access Help has guidelines on building forms and comboboxes.
    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. Help or Guide to Particular Form Setup
    By Zephyx in forum Forms
    Replies: 2
    Last Post: 06-27-2013, 03:53 PM
  2. Replies: 26
    Last Post: 06-14-2013, 10:57 AM
  3. MS Access Form/Query Setup
    By Datatech in forum Database Design
    Replies: 5
    Last Post: 05-31-2012, 12:08 AM
  4. Replies: 1
    Last Post: 08-19-2011, 02:53 PM
  5. Best way to setup
    By griz47 in forum Access
    Replies: 5
    Last Post: 05-17-2011, 12:59 AM

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