Results 1 to 2 of 2
  1. #1
    stupesek is offline Advanced Beginner
    Windows 7 Access 2007
    Join Date
    Sep 2010
    Posts
    46

    Lab information database problem

    I am building a new reporting database for a small laboratory I own. The one I built and used before crapped and I thought, but did not have it Carbonited. Anyhow, I am building a new one with these relational tables many to one.



    [Customer] - many reports
    [Report] - may have one to many samples
    [Sample] - may have one to many analysis
    [Analysis] - hundreds of analytes to choose from
    various other look-tables

    I have a sample log-in form that the office help inputs the information supplied by the customer one Report at a time. It has a sub form to enter the one -> many samples for each Report.

    This is what I am looking for a way to do: Since each Sample can have one -> many Analysis, I don't want the office help to have to choose each of those Analysis items on at a time. Especially since most of the Analysis have some sort of routine grouping. (i.e. Test Package 1 = Analysis1+Analysis2+Analyis5; Test Package 2=Analysis2 through Analysis7; Test Package3 = Just Analyis4; and so on) I am looking for a way for my office help while entering new information on each Sample in the sub-form to choose a Test Package that appends the various Analysis for a Sample from a Test Package table.

  2. #2
    HiTechCoach's Avatar
    HiTechCoach is offline MS MVP - Access Expert
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jul 2010
    Location
    Oklahoma, USA
    Posts
    702
    In inventory terms this is called an explosive kit.

    I use a "kits" (test_panels) table with a sub/child table that contains all the items for the kit.

    I would use a pop-up for where the user can select the Test Panel (kit) from a combo box and use a command button to run a append query to add all the item form the kit to the Test Results "report".

    I have done something like this before where I actual import all the data for the test results from the lab.

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

Similar Threads

  1. database problem
    By lukifer in forum Access
    Replies: 3
    Last Post: 07-17-2009, 07:39 AM
  2. database problem
    By st3ven_J in forum Access
    Replies: 0
    Last Post: 02-12-2009, 07:27 AM
  3. Database Design Problem
    By Kurth in forum Access
    Replies: 0
    Last Post: 08-14-2008, 04:09 AM
  4. problem with my database
    By skylinekiller in forum Access
    Replies: 1
    Last Post: 01-25-2008, 02:12 PM
  5. Need help with database to display vehicle information
    By jlmnjem in forum Database Design
    Replies: 1
    Last Post: 07-25-2006, 08:48 PM

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