Hi, I am new to this module and i am having trouble setting up editing.  I am trying to setup update.  I can update the information, but it updates every record in the database, so i end up having 430 records that are duplicates.  I am hoping somebody can help me out here.   Here is my setup

Key Column = StoreNum

Update Statement

update location
set
[Edit:N:2] = '[Edit:V:0]',
[Edit:N:2] = '[Edit:V:1]',
[Edit:N:2] = '[Edit:V:2]',
[Edit:N:3] = '[Edit:V:3]',
[Edit:N:4] = '[Edit:V:4]',
[Edit:N:5] = '[Edit:V:5]',
[Edit:N:6] = '[Edit:V:6]',
[Edit:N:7] = '[Edit:V:7]',
[Edit:N:7] = '[Edit:V:8]',
[Edit:N:7] = '[Edit:V:9]'

Select Statement   

select *
from location
where storenum = '[EDIT:KeyValue]'

Database Table

Name = location

Columns  - all are nvarchar and no primary key.  When i chose storenum as the primary key, i get an error when i save the update

LocationID
StoreNum
Address
City
State
Zip
ContactNum
SiteSurveyDate
InstallDate
Team