COMPANY COMPANY_DOCUMENT DOCUMENT
CompanyID CompanyID DOCUMENTID
Name DocumentID Name
many to many relationships
now instead of making the user write the autonumbers in the COMPANY_DOCUMENTS, I made a dropdown list with the name of the company and the documents.. is this good?
If so now... COMPANYDOCUMENT will be link to another table and in this other table I would like to have a dropdown list that would say... companyname and documentname all in one dropdown list but it doesnt work?