As I said, I am just Fumbling through this with almost no understanding of what I am doing.
recently uploaded my back end tables to a server via SQL Server (not me, I had to have someone else do it) now I am just trying to go through and get everything working like it did when it was a single access db
anyway, I was trying to enter a new record in a subform
i can enter the information into the new record line but cant move forward from there (which makes sense because of the error is saying i have a null somewhere)
the error is
[Microsoft][SQL Server Native Client 11.0][SQL Server] Cannot insert the value NULL into column 'DuesTrackID',table'db789011d180ae44c8acc5ad100006 8.dbo.tbl_ChapterDuesTrack'; column does not allow nulls. INSERT fails(#515)[Microsoft....... The statement has been terminated(#3621)
I understand this is saying I cant insert a NULL into the column 'DuesTrackID'
I don't understand why it is trying to insert a NULL into that column (maybe a stupid question but shouldn't it be auto entering the next ID# if it is the PK Field)
Thanks for the help,