Results 1 to 2 of 2
  1. #1
    Steven.Allman is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Feb 2010
    Posts
    118

    Sharepoint Custom Primary Key?

    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!!!

  2. #2
    JLatos is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2014
    Posts
    1
    Steven, did you ever find a solution to this issue, or were you forced to go ahead with using inconsistent updates? I am just starting migration and am facing this same problem.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. subform primary key null value want custom msg
    By raton in forum Programming
    Replies: 1
    Last Post: 03-24-2012, 11:35 AM
  2. Sharepoint for sharing
    By gumbi17 in forum SharePoint
    Replies: 1
    Last Post: 02-02-2012, 09:48 AM
  3. Forms in Sharepoint
    By Desstro in forum SharePoint
    Replies: 2
    Last Post: 01-12-2012, 09:40 AM
  4. How do I know if I have a Sharepoint server?
    By tucker1003 in forum SharePoint
    Replies: 1
    Last Post: 03-03-2011, 10:56 PM
  5. Username For Sharepoint
    By is49460 in forum SharePoint
    Replies: 0
    Last Post: 10-08-2010, 05:40 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums