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

    Join Date
    Jul 2010
    Rep Power

    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
    Columbus, OH
    Rep Power
    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
    __________________________________________________ _____
    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
    Rep Power
    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