SELECT [AccountID], [AffiliateID], [Password], [StartDate], [Referrals], [Sales], [Active] FROM [Accounts] WHERE [AffiliateID]='#key#' SELECT [AffiliateID] FROM [Accounts] WHERE [AffiliateID]='#tmpFld#' Duplicate value for index or primary key -- AffiliateID, value = #tmpFld#
 Press [Back] to continue! UPDATE [Accounts] SET #ToString(strsql)# WHERE [AffiliateID]='#key#'

Edit TABLE: Accounts

Back to List

Account ID  #x_AccountID# 
Affiliate ID   
Password   
Start Date   
Referrals   
Sales   
Active