Setup: One Serial and Multiple Installed Software

[george.e.sullivan]

Hello all,
I have three tables Employess, Equipment, and Software.

I have tried without success to figure out how to show a single
Equipment Serial Number show all the software installed on that
machine.

For example: if the Equipment Table had Serial Numbers: 123 and 456 in
it. And the Software Table had Widget Version 4, Fishing Version 2,
and Vacation Version 10 in it.. How would I show in a Form:

Serial Number: 123
Installed Software
1. Widget Version 4
2. Vacation Version 10

Then Click the next button and this page would show
Serial Number 456
Installed Software
1. Fishing Version 2
2. Widget Version 4

My Equipment table of course has lots of other fields like location,
manufacturer, model, etc and my Software table has lots of other fields
like purchase date, patch level, etc.

Maybe my table design is wrong, I just don't have the experience to
know.
Any help would greatly appreciated.

Thanks to all,

[george.e.sullivan]

Oh Yeah, I am using Microsoft Access 2003.

[paii, Ron]

You have a M-M between Equipment and Software, you will need a 4th table
listing Equipment serial number and Software ID number

<ge***************@saic.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...

Hello all,
I have three tables Employess, Equipment, and Software.

I have tried without success to figure out how to show a single
Equipment Serial Number show all the software installed on that
machine.

For example: if the Equipment Table had Serial Numbers: 123 and 456 in
it. And the Software Table had Widget Version 4, Fishing Version 2,
and Vacation Version 10 in it.. How would I show in a Form:

Serial Number: 123
Installed Software
1. Widget Version 4
2. Vacation Version 10

Then Click the next button and this page would show
Serial Number 456
Installed Software
1. Fishing Version 2
2. Widget Version 4

My Equipment table of course has lots of other fields like location,
manufacturer, model, etc and my Software table has lots of other fields
like purchase date, patch level, etc.

Maybe my table design is wrong, I just don't have the experience to
know.
Any help would greatly appreciated.

Thanks to all,

[george.e.sullivan]

Thanks Ron.

I'll give that a try.

George