Spikemannen
Instructor
Hi!
I'm going nuts over here.
I have a table with Objects.
tblObjects
ObjectID (calc)
Object_name (text)
Avaible_from (date)
Avaible_to (date)
etc...
And I have a table for booking.
tblBooking
BookingID (calc)
Name (text)
Phone (text)
Object (relation to tblObjects)
Book_from (date)
Book_to (date)
etc...
Now, I should only be able to book the specific object between tblObjects.Avaible_from.value to tblObjects.Avaible_to.value.
And when I have made a booking for an object, ofcourse I should not be able to book the same dates for another person (tblBooking.Name.value).
How will I do?
Please, help me...
Best Regardz,
Spikemannen
I'm going nuts over here.
I have a table with Objects.
tblObjects
ObjectID (calc)
Object_name (text)
Avaible_from (date)
Avaible_to (date)
etc...
And I have a table for booking.
tblBooking
BookingID (calc)
Name (text)
Phone (text)
Object (relation to tblObjects)
Book_from (date)
Book_to (date)
etc...
Now, I should only be able to book the specific object between tblObjects.Avaible_from.value to tblObjects.Avaible_to.value.
And when I have made a booking for an object, ofcourse I should not be able to book the same dates for another person (tblBooking.Name.value).
How will I do?
Please, help me...
Best Regardz,
Spikemannen