Results 1 to 4 of 4

Need some design advice

  1. #1
    messingerjc is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2012
    Posts
    2

    Need some design advice

    I am in the military and am trying to design a database for my platoon that can help track our missions and vehicles. I have a general idea in my head on how I would like it to work, I'm just having issues on how to translate it into Access and get it to work. I have a table that contains all of the vehicle & trailer information. I have another table that contains all of the information dealing with any vehicle requests we receive, to include the start/end date & start/end time. I need to assign vehicles/trailers to each mission. The problem I'm having is that each vehicle request may require a different number of vehicles/trailers. So to get around that problem, I was thinking about doing a vehicle/trailer subform to allow the multiple combinations of vehicles/trailers.



    Ok, up to now shouldn't be too hard to get it working. On the subform I want to select the vehicles or trailers from a drop down list, but I would like the drop down list to only display the vehicles/trailers that are not on a mission during the dates/times listed in the current vehicle request.

    Is there a better design I can use to accomplish my task than what I am trying or am I going in the right direction with my design and just need further guidance with the programming? Any help I can get with this would be greatly appreciated!

  2. #2
    tanvi is offline Competent Performer
    Windows XP Access 2010 32bit
    Join Date
    Mar 2012
    Posts
    100
    Good database design includes some principals:


    1) Purpose of designing a database.
    2) Diving all information in to tables
    3) Don’t use duplicate information.
    4) Correctness and completeness of information
    5) Apply normalization rules & many more things.


    Before creating the database, first read these two articles, it will help you to design a good database:
    http://office.microsoft.com/en-us/ac...005187442.aspx
    http://office.microsoft.com/en-us/ac...001224247.aspx

  3. #3
    recyan's Avatar
    recyan is offline Expert
    Windows 2K Access 2000
    Join Date
    Dec 2011
    Posts
    662
    Assumeing something like below :
    tblMissions
    MissionID - PK
    .....

    tblVehicles
    VehicleID - PK
    ....

    tblMissionsVehicles
    MissionVehicleID - PK
    MissionID - FK
    VehicleID - FK
    Reqd_Start_Date
    Reqd_End_Date
    .....

    Check out if below gives some guidelines :

    http://www.baldyweb.com/OverLap.htm

    Thanks

  4. #4
    messingerjc is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2012
    Posts
    2
    I read both of those articles several times in the past. Looking at the example I think it might have given me a couple of ideas to try and work with. Give me a little time to work on this and I'll get back to you on my findings. Thanks again for your assistance.

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

Similar Threads

  1. DB design advice (warning: beginner content!)
    By Rattykins in forum Access
    Replies: 1
    Last Post: 05-09-2012, 07:52 AM
  2. Need some advice and help
    By winterh in forum Access
    Replies: 9
    Last Post: 04-18-2012, 06:41 AM
  3. Replies: 5
    Last Post: 04-02-2012, 08:24 AM
  4. design advice
    By Sarge, USMC in forum Database Design
    Replies: 4
    Last Post: 10-06-2010, 07:53 AM
  5. Need advice on what I have so far
    By rumplestiltskin in forum Database Design
    Replies: 2
    Last Post: 05-25-2006, 12: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
  •  
Tech Forums: Microsoft Office Forums