Ok i have posted this before but the thing is with this website when something is posted it gets forgotten. i need to ask for help. i'am doing a project for my AS It course. i need some help. i'am doing a video rental shop and i need to know how i can be reminded when an item is over due. i will tell you what tables i have got.
employer
employee
item list (item ID, Item name, booked, booked by, booked from, Booked until)
Members
.
i have linked members and item list together and this has formed a relationship. when i type in a booked by, booked from, booked until the data shows up on the members details. here is where my problem lies.
i need to have a form or thing that tells me when something expires. when someone has an item out that is overdue.
if you could help me in anyone way i would be very thankfull.
employer
employee
item list (item ID, Item name, booked, booked by, booked from, Booked until)
Members
.
i have linked members and item list together and this has formed a relationship. when i type in a booked by, booked from, booked until the data shows up on the members details. here is where my problem lies.
i need to have a form or thing that tells me when something expires. when someone has an item out that is overdue.
if you could help me in anyone way i would be very thankfull.