Results 1 to 5 of 5
  1. #1
    bid19123 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2016
    Location
    Cayman Islands
    Posts
    15

    Angry Seems like a simple task but I just cant do it.

    I need to assign a list of 10 employees to vehicles on a daily basis.
    Each vehicle can have multiple employees
    Vehicles are then assigned to a work area
    Each vehicle can be assigned to multiple work areas on any given day.

    I want to create a form that lists the 10 employees and assign them to vehicles (also need to include absences)
    I then need a second form that details vehicles work areas.

    This seems simple but I cannot get my head around it as there are 3 levels; employee, vehicle and work area for each date; each vehicle can have multiple employees and work areas.

    Any suggestions about table design, links and queries would be greatly appreciated.

    Thanks

    Alan

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Maybe:
    tblEmployee (EmpID, EmpName, etc.)
    tblVehicle (VehID, VehDescription, etc.)
    tblWorkArea(WAID, WALocation, etc.)
    tblAssigned (AssignID, EmpID, VehID, WAID, AssignedDate, AssignedTime)
    Link the first 3 to tblAssigned by their IDs. tblAssigned holds all the detail of what gets assigned. Have a main form for tblAssigned and use combo boxes to select the other ID values into the assigned form. Once you have the data, you should be able to produce reports or other forms with what you need.

  3. #3
    bid19123 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2016
    Location
    Cayman Islands
    Posts
    15
    Thanks Bulzie I will give this a try.

  4. #4
    bid19123 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2016
    Location
    Cayman Islands
    Posts
    15
    Bulzie,

    The data is collected correctly but input in a form is problematic. Ideally I wanted a form that has a calendar date field and then lists all 10 employees along with a vehicle assign field that can be updated. After this has been filled out I envisaged a second form that has the date field then vehicle # and a subform with employees and then another subform that has a dropdown of work areas. Do you think this is possible with the table set up that I have. I will work on this tomorrow as it has fried my brain today! Thanks

  5. #5
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Can you give a sample of the data and how you want it to look on a form for 1 day.

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

Similar Threads

  1. Task
    By kid_viciouss in forum Access
    Replies: 2
    Last Post: 11-25-2016, 04:15 PM
  2. Replies: 2
    Last Post: 06-24-2016, 05:46 PM
  3. Task Reminders
    By burrina in forum Sample Databases
    Replies: 2
    Last Post: 06-18-2014, 10:31 AM
  4. Simple task but must be fast
    By Colman in forum Programming
    Replies: 4
    Last Post: 09-10-2011, 05:27 AM
  5. Very simple task - create many-to-one realtion
    By ganjan in forum Database Design
    Replies: 3
    Last Post: 06-03-2009, 01:57 PM

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