Hi Everybody,
Apologies if in wrong section
I am designing a DVD Movie Collection Database for my own personal use and requiring a little help.
Brief description: The key tables are tblMovies, tblLoans with the following key fields
MovieID (Autonumber)
MovieTitle
Status: Available or Not Available
LoanID
MovieID
MemberID
LoanStatus: Status Loaned or Returned
My query is there a way to store multiple Movies Title with the same Movie ID.
Scenario: DVD contains the movies Saving Private Ryan, Spiderman, Star Wars and a friend loans the DVD, I would like it to be in effect all three movies status “Not Available”.
I already know I could put all 3 movies in the one field MovieTitle, which will fix this, but this isn’t a good solution as this won't sort my movies into a true alphabetical order and movie count would not be accurate
If somebody has any tips or advice, or if my thinking is wrong please reply