X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Vehicle Assignment Scheduling Structure, Access 2016    
post Oct 4 2019, 02:47 PM

Posts: 6
Joined: 20-February 19

I'm attempting to optimize table structure for a vehicle reservation/assignment database. Users submit a reservation for a vehicle type for a date range, then an admin assigns a vehicle, and the user checks the vehicle back in when completed. The business process has changed from a user requesting a vehicle a day or so ahead of time to now requesting it at least a week ahead of time. Ideally, I'd like to switch over to a proper calendar booking system - or at least something that would be more flexible in determining what days a vehicle is truly available. This was my first attempt at a junction table format, so it's very likely that it's a mess (my apologies and thanks in advance).

What unnecessary relationships can be deleted in the attached table relationship? Should the table structure be modified?

Thanks for all of your assistance!
Attached File(s)
Attached File  2019_10_04_14_26_03.png ( 113.32K )Number of downloads: 19
Go to the top of the page
post Oct 4 2019, 05:30 PM

Utterly Eccentric and Moderator
Posts: 4,081
Joined: 4-March 00
From: Bristol / Ipswich / Spain

I have a demo for available/booked items HERE Although its for holiday rental properties, the theory is the same as for vehicles. Consider carefully the notes in the included report. This also allows you to print a spreadsheet type plan of bookings but would need some modification if you change the base table names.



I would like to remind members and visitors that UtterAccess is a NON SMOKING website. In that respect, it is the worlds first Thank you for not smoking.
Go to the top of the page
post Oct 8 2019, 08:01 PM

Posts: 3,360
Joined: 27-February 09

Didn't Tony Toews write something like this for fleet management? Whatever happened to it?
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    15th November 2019 - 09:10 PM