I am trying to write a db design for Film Breakdown Sheets. They basically allow me to input specific information about each scene into a form. The problem occurs with input types like "Characters ." If John and Nick are both in a single scene, how do I tell Access that.
-
-
There is a thread (Normalisation and Table structures) which is designed to help with questions such as this. -
Basically you need to create another "relation table" holding the key of the Scene and of the Actor.
Translated to a form this will require a Scene form with a subform showing the related Actor(s) or and Actor form with a subform showing the Scene(s).
Nic;o)Comment
Comment