假设公司表名:CompanyDoc,  字段为CompanyID, CompanyName
    员工表名: EmployeeDoc, 字段为EmployeeID, EmployeeName

解决方案 »

  1.   

    界面中实现,应该是javascript的问题吧。
      

  2.   

    <html>
    <head>
    <title> New Document </title></head>
    <body>公司列表:
    <select id="Company" onChange="select()">
    </select>员工列表:
    <select id="Employee"></select>
    </body>
    </html>
    <script language="JavaScript">
    <!--
        //公司表名:CompanyDoc,  字段为CompanyID, CompanyName
        //员工表名: EmployeeDoc, 字段为EmployeeID, EmployeeName
    CompanyDoc  =new Array
    EmployeeDoc =new Array
    CompanyDoc[CompanyDoc.length]=["01","公司一"]
    CompanyDoc[CompanyDoc.length]=["02","公司二"]
    CompanyDoc[CompanyDoc.length]=["03","公司三"]
    CompanyDoc[CompanyDoc.length]=["04","公司四"]
    CompanyDoc[CompanyDoc.length]=["05","公司五"]EmployeeDoc[EmployeeDoc.length]=[1001,"小张","01"]
    EmployeeDoc[EmployeeDoc.length]=[1002,"小李","01"]
    EmployeeDoc[EmployeeDoc.length]=[1003,"小王","01"]
    EmployeeDoc[EmployeeDoc.length]=[1004,"小武","02"]
    EmployeeDoc[EmployeeDoc.length]=[1005,"小熊","02"]
    EmployeeDoc[EmployeeDoc.length]=[1006,"小猫","03"]
    EmployeeDoc[EmployeeDoc.length]=[1007,"小狗","03"]
    EmployeeDoc[EmployeeDoc.length]=[1008,"小猪","04"]
    EmployeeDoc[EmployeeDoc.length]=[1009,"小羊","04"]
    EmployeeDoc[EmployeeDoc.length]=[1010,"小鱼","05"]
    EmployeeDoc[EmployeeDoc.length]=[1011,"小牛","05"]for(var i=0 ; i<CompanyDoc.length ; i++){
    tempOption =new Option(CompanyDoc[i][1],CompanyDoc[i][0])
    Company[Company.length]=tempOption
    }
    function select(){
    index=Company[Company.selectedIndex].value
        Employee.outerHTML="<select id='Employee'></select>"
    for(var i=0;i<EmployeeDoc.length;i++){
    if(EmployeeDoc[i][2]==index){
    tempOption =new Option(EmployeeDoc[i][1],EmployeeDoc[i][0])
    Employee[Employee.length]=tempOption
    }
    }}
    //-->
    </script>
      

  3.   

    看看这个,或许对你有帮助。
    http://www.chinabs.net/js/listdropdownmenu.asp