Store More than one value in a field without using lookup.

[MichaelA]

I think I'm going to wind up feeling like an idiot for not being able to figure this out but I can't. I'm making a simple movie database. It will have movie titles, genera, and movie format (i.e. DVD, Blueray, etc.) I have three tables, tblMovies, tblGenera, and tbleFormat. My problem and question is, some movies fit into more than one Genera. How do I store numerous genera in a table cell without using the dreaded "lookup?"

Thank you!
Michael

[June7]

Only other way is as a CSV string.

Advise not to store multiple data elements in a single field. Use a dependent related table where each movie/genre pair is a record.

[MichaelA]

Only other way is as a CSV string.

Advise not to store multiple data elements in a single field. Use a dependent related table where each movie/genre pair is a record.

Would a user have to enter each movie/genre pair separately?

[June7]

Of course, it's called "data entry".

However, could use a linked subform so movieID automatically populates in dependent record and user only has to select genre.

[MichaelA]

Of course, it's called "data entry".

However, could use a linked subform so movieID automatically populates in dependent record and user only has to select genre.

This sounds like a decent option. Back tot he drawing board.

Thank you!

[Mickjav]

I would use
tblGenera Holds each Genera
tblMoviesGenera Would be a many to many table between movies And Genera

Create 2 primary keys GeneraID and MovieID in tblMoviesGenera

This way you could add more that one Genera per movie.