|02 Jan 2011||#1|
| || |
MS Access 2007 - Multiple records in one row... How??
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.
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?
|My System Specs|
|Similar help and support threads for2: MS Access 2007 - Multiple records in one row... How??|
|Access 2007/2010 what is the differences||Microsoft Office|
|Any problems using Access 2007 database with Access 2010?||Microsoft Office|
|Cannot access the Ribbon functions in Excel 2007 or Word 2007||Microsoft Office|
|Access 2007||Microsoft Office|
|Anyone very knowledgeable in Access 2007||Microsoft Office|
|Fixing iso file..Need Access 2007||Microsoft Office|