Results 1 to 2 of 2

Thread: Define acceptable values for column

  1. Sep 23rd, 2003, 06:24 AM #1
    PORRASTAR
    PORRASTAR is offline

    Thread Starter
    Addicted Member
    Join Date
    Sep 2002
    Location
    Cape Town, SA
    Posts
    144

    Define acceptable values for column

    Hi

    I havea user column in my table. I want the the value of this to be limited to "User1", "User2" or "user 3". Is there a way in SQL that I can define these 3 values to be in a dropdown in the field when I choose that field?

    Thanking you in advance

    PORRASTAR
    Reply With Quote Reply With Quote
  2. Sep 23rd, 2003, 06:28 AM #2
    Lightning
    Lightning is offline
    Frenzied Member Lightning's Avatar
    Join Date
    Oct 2002
    Location
    Eygelshoven
    Posts
    1,611
    Maybe if you use a inne join to a table that contains those 3 values.
    VB6 & C# (WCF LINQ) mostly


    If you need help with a WPF/WCF question post in the NEW WPF & WCF forum and we will try help the best we can

    My site

    My blog, couding troubles and solutions

    Free online tools
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width