Results 1 to 4 of 4
  1. #1
    GerryVB is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Location
    Sherwood Park, AB
    Posts
    2

    Question Advice on relationship design

    Hey there experts,


    I am developing my own database for a small engine repair business. I have been using Excel for years, but I need more power and flexibility. Could someone have a look at my design to see if there are any glaring errors with my logic? I want to have it setup fairly well before I start to import all of the data from my spreadsheets.

    I think it should be fairly self-explanatory, but if you need and clarification, feel free to ask for it.

    Thanks in advance!

    Click image for larger version. 

Name:	Database Relationship Structure.JPG 
Views:	28 
Size:	102.8 KB 
ID:	41425

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Suggest not using exact same field name in multiple tables.

    Advise not to use space in naming convention - that includes names of tables, queries, forms, reports.

    Why is EmployeeID in both WorkOrders and WorkOrder Labor tables?
    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
    GerryVB is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2020
    Location
    Sherwood Park, AB
    Posts
    2
    Thank you, June7.
    You are right...The employee should only be connected to the labor table. Thank you for the catch. I will also remove the spaces from the headers and titles.

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

    Would also recommend that you use the standard naming convention for Objects ie tblCustomers, tblWorkOrders etc.

    You would use frm for Forms, rpt for Reports and qry for Queries.

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

Similar Threads

  1. Seeking Relationship Advice
    By kd2017 in forum Database Design
    Replies: 8
    Last Post: 02-06-2018, 05:37 PM
  2. Relationship / Form Advice
    By StevenCV in forum Access
    Replies: 1
    Last Post: 02-06-2014, 06:54 AM
  3. many-to-many relationship advice
    By REBBROWN in forum Database Design
    Replies: 1
    Last Post: 04-28-2013, 09:42 PM
  4. Need some design advice
    By messingerjc in forum Database Design
    Replies: 3
    Last Post: 06-18-2012, 06:16 PM
  5. design advice
    By Sarge, USMC in forum Database Design
    Replies: 4
    Last Post: 10-06-2010, 07:53 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