I tried to delete a record from Table1, using form 1. I have a JOIN between my tables, and when my backend was ACCESS, the UIC column was the primary key for Unit Information, and for Personnel it was the SSN.
If I was adding billy, then his SSN 123-12-1234 and when I went to put his UIC in table1, it would use my join to look for that UIC in table2(unti information) and populate several other fields in my forms, and thereby my reports. Great...
Sharepoint lists aparently must have an autonumber PK, which means my forms would create "Recordset not updateable" unless I did Dynaset inconsistent updates.
Then when I went to delete a person(record from table1) the other day, I also deleted the UNIT from table2.
This cannot happen.
How can i force sharepoint to allow my UIC field and my SSN field be the PK, so that I may change my form attributes back to Dynaset, and everything be happy!!!