Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / April 2005

Tip: Looking for answers? Try searching our database.

table design /sql question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Stefan - 25 Apr 2005 13:38 GMT
Hello,
I'm new at database design and I'm trying to make my first real program.
Administration /reservation of numberplates to be used in car garage
now the following fields are in the database
-user who made the input
-date/time out
-date/time back
-customer name
-destination
-memo
-back (yes/no)
-out (yes/no)

now i can see which numberplates are out and which are still available

So , i want to add a new module(the reservation of plates)
When i customer comes in and asks for  using any numberplate,
i want to give in the date/time out date/time back and i when i push the
button
i want a grid filt with available license plates in that period
Now i'm not sure how to do the reservation part in table design.
Any suggestions
Allen Browne - 25 Apr 2005 15:33 GMT
To find the vehicles that are available from one date/time to another, you
need to locate those have no booking for any period in that timeframe. The
basic idea is that two events overlap if both:
   A starts before B ends, and
   B starts before A ends.

If you have to handle Nulls (e.g. not known when the vehicle will be back),
it gets a bit more involved. See:
   Clashing Events/Appointments
at:
   http://allenbrowne.com/appevent.html

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hello,
> I'm new at database design and I'm trying to make my first real program.
[quoted text clipped - 18 lines]
> Now i'm not sure how to do the reservation part in table design.
> Any suggestions
Stefan - 25 Apr 2005 16:50 GMT
thanx allen
that's what i was looking for
> To find the vehicles that are available from one date/time to another, you
> need to locate those have no booking for any period in that timeframe. The
[quoted text clipped - 30 lines]
> > Now i'm not sure how to do the reservation part in table design.
> > Any suggestions
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.