I am creating a movie rental database in Access that will work in a similar way to Netflix or Lovefilm, where rentals are not charged by individual rentals, but as part of a subscription where a user can rent a certain amount of DVDs at once. It's been a while since I've used Access and I'm not finding it that easy getting back into it. By the way, this database will be used to power some ASP in a website (of which I have never done before, so I want to make sure it is correct before going any further!)
I have set up all the tables I want to create, but I am unsure of whether the relationships are set up correctly and whether I have done it in the most efficient way. I haven't yet entered data in the database, but I have a feeling that I have not set up the relationships correctly for the tables in the red box. Can someone check my relationships for me and if there are some problems, suggest the way to resolve them? I know if they're not right now, then it can have major implications!!
Thanks in advance!
Here's the screenshot: http://dl.dropbox.com/u/43666839/Mov...ationships.png