Cataloging Film Cartridges & Pictures Taken

[Mark W.]

I am seeking ideas/samples/templates on designing a DB where I can catalog film cartridges and the individual frames taken. For example: Cartridge # 0001 is a 24 exposure roll and frames 1 through 6 are taken by one individual, frames 7 through 18 by another, and frames 19 through 24 by yet another

I wish to be able to list the frames taken for each roll of film and be able to retrieve them by the individual who shot them. Any help would be appreciated! Thanks in advance :-

Mark W.

 

[John Nurick]

Hi Mark,

You'll need at least the following tables:

tblPersons
PersonID (primary key)
fields for name and other stuff

tblFilms
FilmID (primary key)
Format
FilmType
other fields

tblFrame
FrameNumber ) 2-field
FilmID ) primary key
PersonID (person who took it)
Date
other fields (e.g. subject)