This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I am currently evaluating Lightspeed and have a need to be able to create a column that will be used as the primary key and then populate it. For example take a Products table. -PartNumber = Primary Key -Description Etc. I would not want the part number to be an auto incremented value, but specified in a form before inserting. From there would want to relate other tables on that column. Is this possible? |
|
|
|
|
For information about setting your own primary key value instead of allowing LightSpeed to assign it, see the docs chapter on natural keys: http://www.mindscapehq.com/documentation/lightspeed/Working-with-Legacy-Databases/Using-Natural-Keys Note that the primary key is always surfaced as the Id property of the entity. This can be mapped to another database column using the Identity Column Name setting, but in your application you will refer to it as Id. Of course you can create a wrapper property to alias it so that your application code can use the business-meaningful term: public int PartNumber { get { return Id; } } |
|
|
|
