Results 1 to 9 of 9
  1. #1
    Voodeux2014 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Nov 2014
    Location
    Slidell, LA
    Posts
    130

    Question Ideas?


    I have a form that has multiple subforms with different queries. After selecting an employee from the combobox it autoqueries the form and trickles down to the subform so that only information for that employee is shown. I would like to know if there are alternatives for showing this information rather than a bunch of different tables on a form?

  2. #2
    Demerit's Avatar
    Demerit is offline Competent Performer
    Windows 7 32bit Access 2007
    Join Date
    Nov 2013
    Posts
    125
    This depends on the structure of your database
    The information on many tables for the same employee..... why not use fewer number of tables? One or Two
    In this case, one is the parent table and one is the child table.

    Why do you have so many tables containing information about the same person?

  3. #3
    Voodeux2014 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Nov 2014
    Location
    Slidell, LA
    Posts
    130
    I have it set up to where the employee information is in one table with a link to department and location tables. I have it show all devices in one table, accessories in another, phone information in another, and software licenses in another. How do I slim this down further to do as you said?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    This is an asset tracking db? You filter the subforms to show only the assets assigned to employee? What is the main form data source?

    Software is assigned to employee? Software should be assigned to device.

    Have you looked at the MS assets tracking database template?

    If you want to provide db for analysis, follow instructions at bottom of my post.
    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.

  5. #5
    Voodeux2014 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Nov 2014
    Location
    Slidell, LA
    Posts
    130
    Correct june. It is an asset tracking db. I did check out the MS one but wanting to build from scratch to better familiarize myself with access at the same time. Currently I have multiple queries in place that are on the main form. The main form data source is the employee table.

    Queries:
    Employee Devices (shows all devices that are currently assigned to that employee)
    Software (shows all the software that is associated to that device)
    Accessories (shows all accessories assigned to the above device)
    Ports (shows switch/wall port and extension assigned to the employee)

    Once you select an employee from the combobox on the main form it displays that employee's name and location along with a table for each of the queries mentioned to display everything on that employee.

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    You have Master/Child Links properties of the subform containers set?

    Can use listbox to show related data but listbox is not editable. Do you want to be able to enter/edit related data?

    Form/subform arrangement is conventional method and usually best approach.
    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.

  7. #7
    Voodeux2014 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Nov 2014
    Location
    Slidell, LA
    Posts
    130
    Yes the master/child links are set. I was just trying to see if there was a better looking way to display the information. The information does not need to be editable as I have a separate form for that.

  8. #8
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    Better way is matter of perception here. You might like listboxes - or not. I sometimes use listboxes to display related data. This will require code to requery the listboxes if you allow record navigation. I use the form Current event.
    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.

  9. #9
    Voodeux2014 is offline Competent Performer
    Windows 7 64bit Access 2013
    Join Date
    Nov 2014
    Location
    Slidell, LA
    Posts
    130
    Ok got you. Thanks june.

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

Similar Threads

  1. Design Ideas
    By ajs112 in forum Access
    Replies: 4
    Last Post: 10-08-2014, 02:35 PM
  2. Need Ideas..
    By athyeh in forum Access
    Replies: 3
    Last Post: 06-26-2013, 11:34 AM
  3. Need your ideas and help...
    By Daryl2106 in forum Access
    Replies: 8
    Last Post: 04-05-2012, 01:00 PM
  4. Any ideas?
    By eripsni in forum Access
    Replies: 9
    Last Post: 08-25-2011, 08:33 AM
  5. Need some ideas
    By amauricio2 in forum Database Design
    Replies: 0
    Last Post: 03-02-2009, 11:03 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