Thanks folks for your help.  This is a great forum.  I am learning a lot.

I have my application working again.  I came across an article on steps to take before...

"If you want to have your newly inserted key returned by sqlserver (i.e. right after you have inserted your row), you could use @@idendity ..."

But that was my problem in...

alzdba

Is there a problem?

I guess whether I use the Composite key route or the concatenation method, I won't need to retrieve the primary key from my Tests table before inserting into my TestDetails table.  I can...

I wrote this application for my students to take my tests online.  When they submit a test I insert their StudentID and DateTime into a table named 'Tests'.  MS Access...

Joseph:

I tried that approach with the same results already.  I realise now that @@Identity grabs the primary key in an Access table, but grabs the last identity in a SQLServer...