DVD Rental Database
all I have so far is 4 tables.customers.DVD's.rentals.and Suppliers.i need to know how to create a input form so I can add new customers but when I try to create a form and then go to pick out the feilds.there is no fields to choose from
Thank you for taking the time to report an issue.
What's wrong... Please write below.
In Stock?(CheckBox) = Yes If DVD ID is in Rental Table Else No
I'm having a little trouble figuring out how to update the stock levels for items in my stock table. It is a DVD Rental Database, so of course I need stock to be subtracted and added back on.
I already have a query for the amount of stock for each item, however, this only shows how much stock is in the 'AmountStock' column of my stock table (the original amount of stock).
I have a form also linked to my Rental Table, which works fine.
Just can't figure out how to make a query for updating stock each time a film is borrowed and returned!
I created an application (1 file accde includes tables) that keeps track of the works of a rental shop.
It consist of tables where different data is stored and it has forms where a user can input data then
it has queries that calculate rental prices and finally it has reports that print invoices.
It works well.
The rental shop wants to change the way they calculate the prices. I can easily change the queries to make new calculations but it creates a problem.
The new queries will change the old invoices by recalculating them. And that should not happen.
1,Keep the old application for historical purposes and use the new version for the new jobs.
That looks the easiest.
2, Save all the old data in the database and stop recalculating them. There is a problem with this because it would save calculated data in the database.
3, Create complex queries that checks data and recalculate old data with the old method and new | data with the new calculations. It looks a bit time consuming task.
In a combo box, I would have a selection of camera gear that would incur a rental fee based on their rental type (Weekly Hire, Weekend hire, Overnight hire etc).
Instead of having a user select both the camera gear and then select the rental type and price in another combo box . how can I have it so that when the user selects the camera item, it will automatically display the rental fee
Apparently I need to add another table. I'm also not sure what type of relationships I should have.
It need not be too complicated eg no need for manufacturer or supplier. I have to be honest my knowledge of Access is not brilliant.
My only problem is that when I check out an item for say a date 2 weeks away from when I am booking the item it lists the item as not available. Therefore if someone wants to rent the item for the upcoming weekend, and have it returned before the next people have it checked out, I can not put it in the system.
If anyone knows how to check out an item for multiple dates and not have it come up as unavailable until theactual rental date,
Thanks so much to all who respond.