Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2010
    Posts
    5

    Unanswered: Autonumber-Dropdownlist

    hey I really need help with this please

    COMPANY COMPANY_DOCUMENT DOCUMENT
    CompanyID CompanyID DOCUMENTID
    Name DocumentID Name
    CompanyDocumentID
    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?

  2. #2
    Join Date
    Jul 2010
    Posts
    5
    oops this doesnt look good...
    COMPANY(CompanyID, Name)
    COMPANY_DOCUMENTS(CompanyID, DocumentID, CompanyDocumentID)
    DOCUMENTID(DocumentID, Name)
    there is also other fields in there

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •