Help understand the underneath logic for update

[xchen88]

Suppose I am using a form to update the table. The form is based on a query,say qrTest. The qrTest selects data from the table. Since the table has ssn(primary key), I used right(ssn,4) to select the ssn in the qrTest. Now of course the ssn field in the form only displays the 4 digit of ssn. Now if I update the records from the form, is there any chance that more than 2 records will be updated due to the possibility that more than 2 records might have the same 4 digits? What's the mechanism in this updating? I know it's updating the underneath table, but won't it grab the 4 digit ssn, something like "Update db set ... where ssn=xxxx"?

I am from the web programming world, so all the update queries have to be tied to a primary key if just update the specific record.

Thanks for your help.

 

[PHV]

The query should select the PK even if no control is bound to this field.
Have a look here:

http://msdn.microsoft.com/archive/en-us/dnaraccess/html/msdn_harness.asp

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886