Many to many? not sure

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top