Many to many? not sure

[Guest]

I am creating a database and I am totally stuck.
I have a table that has a lot of information in it.
Profile, Screen, Description

There are several profiles that use the same screen and Description.

How would I pull that into a query?
I have 10 Profile Names. Not all employees have those profiles. At most they
will only have 4 profiles.

I want a query that will say Employee Profile 1,2,5 Screen # 500
The next one will be Employee Profile 5 Screen #501

Does that make sense?

I set up 2 tables, one with employee information that has 4 fields for
profile data.
That profile data will then point to the second table with the screen data
information,.

Thanks

 

[Steve Schapel]

Squrl,

I am a bit lost from your description - I can't see what a Screen
refers to, or how this fits into the picture.

Please have a look at this article...
http://accesstips.datamanagementsolutions.biz/many.htm
and/or this one...
http://support.microsoft.com/?id=283698

Hopefully you will be able to apply these ideas to your database.