I am fairly new to the world of access and need some help with adding multiple records/lines within one row or something to similar effect. Reason:
I have a table with a list of TV Series, as part of my indexing i would like to break the series down into Seasons and then into episodes.
They way i have done this at the moment (which is no good) is have 2 fields, one for Seasons and one for Episodes.
Both these columns are drop down check box's allowing multiple selections.
The biggest problem i have is when i get to episodes as obviously when i say i have got seasons 1, 2, 3, 4 i know i have those seasons however when i fill in the episodes it doesn't relate to a specific season as it is on the same row.
How do i index the TV Series so episodes relate to each season?