Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    14

    Unanswered: help-about entering data

    Hi,
    I have design a form employees all things are going fine.I have entered data from form ,all the field are getting write value except departmentID no value is assign to this field in the table,y?.I have not mention this field in the form as it is not required also this field is foreign key in the employee table.I have assign one to many relationship between employee and department table.kindly help me.
    Thanking u.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    One-to-many between Employee and department? That means an employee can be in more than one department.
    I suspect what you want is a One-to-many relationship between Department and Employee, and then the Employee.Department_ID field is certainly necessary, must be included on the form (unless you want a default department), and is not going to populate itself.

    How would the database know what department the employee is in? You have to include that on your form.

    blindman

Posting Permissions

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