Results 1 to 2 of 2

Thread: Drop Down Lists

  1. #1
    Join Date
    Jan 2004
    Posts
    18

    Unanswered: Drop Down Lists

    I'm want to be able to choose(including multiple selections) names from a drop down list that are fetched from the database(from table "Employees") and add them to table "Biotechnology".

    Employees(ID,FirstName,LastName)
    Biotechnology(ID,EmployeeID)

    **assuming that EmployeeID in "Biotechnology" is the ID from "Employees" table

    Example: We add Employees.ID(23, 33) to Biotechnology.EmployeeID

    would be

    Biotechnology:
    [ID] [EmployeeID]
    01 - 23
    02 - 33

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    Looks like an INSERT statement to me, possibly complicated by your user interface. What's the problem?
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

Posting Permissions

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