#1
  1. No Profile Picture
    Contributing User
    ASP Discoverer (100 - 499 posts)

    Join Date
    Jul 2010
    Posts
    138
    Rep Power
    12

    Is multiple values in a field possible and/or viable?


    I have a project I'm working on to set up a work order system for our maintenance personnel. We have upwards of 25 employees, and a supervisor will assign one or more employees(usually a max of 6) to a work order. I was trying to avoid having an employee1, employee2...employee25...etc column setup. The original project i was doing was in access, and i could do that there, however i understand sql server express might not allow me to do this. Is there some sort of work around where i could do this, and still query the field for one employee name when it contains multiple values?
  2. #2
  3. Contributing User
    ASP Skiller (1500 - 1999 posts)

    Join Date
    Mar 2005
    Location
    Columbus, OH
    Posts
    1,665
    Rep Power
    283
    SQl server can handle everything access can and mach more...
    in your case it looks like you need 3 tables.
    Orders for all order details and order_ID
    Employees for all your employees info and employee_ID
    and OrderEmployee to keep employee_Order Assignment
    something like Employee_id, OrderID, Date
    GK
    __________________________________________________ _____
    if you found this post is useful click Give Rep button (bottom side on this reply ) and agree
  4. #3
  5. No Profile Picture
    Registered User

    Join Date
    Jan 2014
    Posts
    1
    Rep Power
    0
    You have fime ideas. Really looking forward to read more.I was thinking of using this style for the site . Post is nicely written and it contains many good things for me. I am glad to find your impressive way of writing the post.

Similar Threads

  1. Replies: 3
    Last Post: April 2nd, 2009, 07:41 PM
  2. Insert multiple values into 1 field?
    By vbmntv in forum ASP Development
    Replies: 7
    Last Post: November 28th, 2006, 05:48 AM
  3. Replies: 1
    Last Post: July 7th, 2005, 11:23 AM
  4. Post multiple values for one form field
    By icreate in forum ASP Development
    Replies: 3
    Last Post: August 10th, 2004, 10:04 AM
  5. Count Property-Multiple Values in Same Field Not Working
    By Steve Schofield in forum SQL Development
    Replies: 0
    Last Post: November 24th, 2000, 04:28 PM

IMN logo majestic logo threadwatch logo seochat tools logo