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
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?