Results 1 to 3 of 3
  1. #1
    Marier is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2018
    Location
    North East England
    Posts
    2

    Defining Relationships in Access

    I am trying to create a simple database which allows us to record inspections carried out to our play equipment in our parks. We have 13 parks and over 200 pieces of play equipment, some of these are in more than one park.

    The main tables I have are
    TblParks (ParkID) (ParkName),


    TblEquipment (EquipmentID) (EqupmentName),
    TblEquipment_In_Parks (joining previous 2) (EquipInParksID) (Park) (Equipment),
    TblInspectionDates (InspectID) (EquipmentID) (InspectionID) (InspectionDate)
    TblInspections (InspectionID) (InspectionDateID) (EquipmentInParksID) (Fault) (datecomplete) (comment),etc..

    I have been trying to do this for weeks and despite reading loads of stuff I am still totally lost as to what to link to what, although I think I may have the Parks, Equipment and EquipmentInParks right. Can anyone shed any light please?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    do NOT link to tEquipment. It is a lookup table to insert into
    TblEquipment_In_Park.

    do:
    TblParks.ParkID to TblEquipment_In_Parks.ParkID (1 park owns many equipmt)
    TblInspections.InspectionID TO TblInspectionDates.InspectionID (1 inspection looks at many equipmt)


  3. #3
    Marier is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Nov 2018
    Location
    North East England
    Posts
    2
    Thanks Ranman, I'm still confused. How do I link the inspections to the parks and equipment? I have attached what I have done so far.Click image for larger version. 

Name:	Relationships.PNG 
Views:	6 
Size:	18.3 KB 
ID:	36366

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

Similar Threads

  1. Need Help Defining Custom rows in access table
    By muhammed361 in forum Access
    Replies: 3
    Last Post: 04-12-2017, 02:55 PM
  2. Defining an Array in an Access Table
    By EddieN1 in forum Database Design
    Replies: 9
    Last Post: 10-10-2014, 08:09 AM
  3. Replies: 22
    Last Post: 05-22-2014, 12:25 PM
  4. Replies: 4
    Last Post: 05-07-2013, 11:14 AM
  5. Replies: 10
    Last Post: 09-29-2011, 11:39 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