locked
How to have a different primary key RRS feed

  • Question

  • When I create a table in lightswitch it automatically generated a primary key.

    Is it possible to designate my own primary key?

    I have a 'Products' Table with fields ProductId; ProductDiscription
    I need the productId to be unique
    Ie. I don't want to allow two products to be named Product1

    I assume that this can be done, but how. Cant see anything in the properties window.

    Cheers

    Andy

    Friday, March 23, 2012 5:17 PM

Answers

  • Ok, I get it now

    I have to use the 'unique' property for the productId
    (Actually I thought I'd tried that but guess not used to having to click save before validating)

    Friday, March 23, 2012 5:37 PM

All replies

  • Ok, I get it now

    I have to use the 'unique' property for the productId
    (Actually I thought I'd tried that but guess not used to having to click save before validating)

    Friday, March 23, 2012 5:37 PM
  • Answered
    Friday, March 23, 2012 6:17 PM