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!
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.
What i was able to achieve (by using [DVD or Bluray] in the criterai) is a dialog that lets you input manually DVD or Bluray. Of course if you mispelled you get nothing.I'd like to be able to select the possible values (DVD or bluray) from a list to avoid that and i dont care much for the dialog.
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.
How can I make a dynamic total?
Here's the example.
When someone sales an item, it has to shown the quantity of that item has been reduce. The query shoud show something like this:
SaleQty ItemInStock 256
45 256 DVD plug
44 256 DVD plug
43 256 DVD plug
40 256 DVD plug
39 256 DVD plug
38 256 DVD plug
Other thing is that I really want to learn, so if any can point some good book for learning it will most apreciated (I've already finnish the video course from Lydia.com
These facts define the requirements which the Database must meet and should be agreed between the Database User and the Database Designer prior to physical creation.