Windows 7 Forums
Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: MS Access 2007 - Multiple records in one row... How??

02 Jan 2011   #1

Windows 8.1 Pro x64
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.

MS Access 2007 - Multiple records in one row... How??-capture.png

How do i index the TV Series so episodes relate to each season?


My System SpecsSystem Spec


 MS Access 2007 - Multiple records in one row... How??

Thread Tools

Similar help and support threads for2: MS Access 2007 - Multiple records in one row... How??
Thread Forum
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

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 10:31 PM.
Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33