Many to many? not sure

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Squrl - 12 Aug 2006 00:04 GMT

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

Reply to this Message

Steve Schapel - 13 Aug 2006 08:55 GMT

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.

Signature

Steve Schapel, Microsoft Access MVP

> I am creating a database and I am totally stuck.
> I have a table that has a lot of information in it.
[quoted text clipped - 17 lines]
>
> Thanks

Reply to this Message