Condition in many to many

[fabiobarreto10]

Friends, as I have attached a table company, a table technology and a junction table to create
a many to many.
I'm trying to create a form with combobox cascade. I have two buttons, one to search for another company and
to check for technology.
First I put looking for technology as the source of the line:
SELECT TblTechnology.NameOfTechnology, TblLINKCompany_Technology.TechnologyID
FROM TblTechnology
INNER JOIN TblLINKCompany_Technology ON TblTechnology.TechnologyID = TblLINKCompany_Technology.TechnologyID;
When I open the combo technology, the values ​​are duplicates, because as it is a many to many, the code
technology join table is repeated. What is the condition that I put to show only a single name of technology?
Thank you.

 

[Pat Hartman]

The company combo should be populated with a query of TblCompany. the technology combo should be populated with query of TblLinkCompany_Technology filtered by the company combo.

 

[fabiobarreto10]

Pat hartan, thanks, I did as you told me. It worked perfectly.
Again, thank you.