multiple copies

[iissa]

i am trying to create a software for a video store using vb.
but the database i am using is access to extract the information.
the problem i am having is that i have multiple copies of a specific movie.
say i have 50 copies of the movie gladiator.
i do not want 50 entries in the database.
is there someother way of doing this
say i have a part number for the title of the movie
45628
and the copy number
01
or
50
is there some way of doing this
any suggestions would be very much appreicated

 

[rbowes]

You need to create two linked tables one called "tblMovies" which would contain information about the movie itself: actors, type, year etc... It needs MovieID (usually an autonumber)as the Primary Key. Then create table 2 called "tblMovieItems" first field should be the primary key, another autonumber. Then create a field called MovieID and make it the same datatype as the first table's movieID. This table should then contain other fields that describe what something about each of these movies like transaction history, current renter etc... Then create a one-to-many relationship between the two on the MovieID field.

That should solve the problem

bob