Search results

The database I'm creating is for DVD/Blu-ray rentals. It needs to be able to store customer, order and film information. The film information will contain 3 main actors in the film, the director and what genres the film is it. It will also have the Title, length and year of release. The customer...

Since there is only 2 products, Blu-ray and DVDs and they are rental there won't be ClearanceSales. I hadn't thought of a loyalty program yet. So presuming your way is best (lets be honest it is) I would have my Film(product) table contain the price? Then the Order-Film (OrderDetails) table...

Thanks for the videos jdraw, they helped me organise my Cast and Director tables. Can you explain how your system would work? As far as I understand you, the AgreedUponPrice would have to change with each order thats not sold for the CurrentPrice and the CurrentPrice can't change without...

Hey guys, I have a database I'm creating for DVD/blu-ray sales. I currently have a order system in place in a subform, which uses a combo box to find the customer and fills in all the information in the rest of the subform. One piece of information is the date of sale. I need to be able to have...

Nope thanks, since the information is about actors the chances are incredibly low and being a non-profit database used just by one person he accepted if there were two actors of the same name he would have Tom Cruise and Tom Cruise1. The Composite Unique Index has solved my problem.

Hey I'm totally stuck on how to do this across two fields. I know with one you can just change the Indexed to no duplication but I need there to be duplication across each field, but no duplication when combined. :banghead: I have three fields CastID, Forename, Surname. Only Forename and...