I am trying to use a query to search 2 many to many relationships but i keep getting duplicate results because each record is slightly different.
I have a table with cameras, another users and another formats. I have a table linking cameras to users and another linking cameras to formats so it looks somthing like this:
tblCameras - tblFormatlink - tblFormats
tblcameras - tblUserslink - tblUsers
When i add all the tables into a query i get loads of results as expected because i get a result for every possible combination.
What i want is when i search for all cameras that are suitable for a user who is a beginner is to get just a list of unique cameras. When i do that search at the moment i get a duplicate record for each different format the camera can do.
Is there a way round this?
Thanks
Jonathan
I have a table with cameras, another users and another formats. I have a table linking cameras to users and another linking cameras to formats so it looks somthing like this:
tblCameras - tblFormatlink - tblFormats
tblcameras - tblUserslink - tblUsers
When i add all the tables into a query i get loads of results as expected because i get a result for every possible combination.
What i want is when i search for all cameras that are suitable for a user who is a beginner is to get just a list of unique cameras. When i do that search at the moment i get a duplicate record for each different format the camera can do.
Is there a way round this?
Thanks
Jonathan