Results 1 to 3 of 3
  1. #1
    Fearnsc837 is offline Novice
    Windows 7 32bit Access 2013 32bit
    Join Date
    Jun 2019
    Posts
    1

    Post Trouble with Design

    Hello,
    I am brand new to access and I am designing a database for a laboratory. There are multiple types of tests in multiple tables that need to be able to be combined into a single suite to make adding tests simple for the user. Here is what i have so far, I am just trying to set up associated tests to a product ID. Does this look ok so far?


    Will I be able to add the product ID and get a total price when I generate a report?

    Any Help will be greatly appreciated

    Click image for larger version. 

Name:	output.png 
Views:	18 
Size:	23.0 KB 
ID:	38818Click image for larger version. 

Name:	relationships.png 
Views:	20 
Size:	49.4 KB 
ID:	38817

  2. #2
    Join Date
    May 2018
    Location
    Living in Scotland UK
    Posts
    1,557
    Hi

    Your Multiple Test tables which all contain the same fields should be in 1 Table called tblProductTests.

    You should add a field to this table called TestTypeID

    You should then create a table that would contain a List of all the TestTypes.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I would agree. I would also add that having multiple tables with the PK field name of "ID" is poor programming practice. (And I always rename any controls that Microsoft creates.)

    Object names should be letters and numbers.
    Do not begin an object name with a number.
    NO spaces, punctuation or special characters (exception is the underscore) in object names

    Object names include fields, tables, queries, forms, reports and modules.



    It looks like your design is from a spreadsheet. Spreadsheets are typically short and wide; dB tables are typically tall and narrow.
    Consider this structure:

    Click image for larger version. 

Name:	Fearnsc837.png 
Views:	12 
Size:	62.1 KB 
ID:	38828

    I saw no date fields, so I added two date fields.




    I name primary key fields with a "_PK" suffix.
    I name foreign key fields with a "_FK" suffix.

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

Similar Threads

  1. big trouble
    By harrie in forum Programming
    Replies: 5
    Last Post: 12-07-2016, 11:36 AM
  2. Replies: 5
    Last Post: 09-08-2015, 10:47 PM
  3. Design vs Article (=Design+Materials) problem
    By emihir0 in forum Database Design
    Replies: 14
    Last Post: 04-20-2015, 03:03 PM
  4. VBA Trouble
    By Daryl2106 in forum Access
    Replies: 3
    Last Post: 03-27-2015, 11:53 AM
  5. Table Design -- want to avoid a design that creates blank fields
    By snowboarder234 in forum Database Design
    Replies: 4
    Last Post: 10-08-2012, 10:13 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