Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
eisenber
Starting Member
2 Posts |
 Posted - 2009-03-19 : 14:46:23
|
| I am very new to databases and SQL Server so please excuse me if this question doesn't make sense or is simple-minded. I have form that worked fine with MS Access query as recordset in mdb but am having problem when converting to SQL Server and ADP.I have view:SELECT tblStudentRoster.StudentNum, tblStudentRoster.Name, tblStudentEmail.strEmailFROM tblStudentRoster INNER JOIN tblStudentEmail ONtblStudentRoster.StudentNum = tblStudentEmail.fkStudentNumI use this view as recordset for Microsoft Access Project form for adding and editing email addresses. There are three columns: Num, Name, EmailAddressI can edit email address when there is data present but when I've got NULL I cannot enter value. It tells me "You can't update the record because another user or application deleted it or changed the value of its primary key."I'd like to be able to add email address and have StudentEmail table updated with correct foreign key. I assume it's something very simple that I just don't have a clue about.Thanks in advance. |
|
|
|
|
|
Converting from Access MDB to ADP