Access Upload to Sharepoint List

Please help. I'm extremely frustrated with above functionality. I created frontend in access which works as local files and then uploaded to Sharepoint. There are MANY frustrating things that just don't work, but I'll start with one. I'm posting here as I got no responses from two Access groups in 3 days. I've been working for 10 days to try to solve this problem.

My tables/relationships are as below

After uploading, the keys (primary and foreign) are changed. It appears the foreign stay, but the some of the primary's are gone. For example, Access above shows a pk of Call.ID. Sharepoint shows below

Notice no ID! Also, when i look at the indices

Notice - NONE! 

When using vba to reference the key, I get

This happens after typical vba me.dirty=false which instantiates a key for a new record!

What the heck IS MICROSOFT DOING? Does anyone use this functionality? I'VE BEEN WORKING ON THIS FOR WEEKS AND HAVE NOTHING BUT PROBLEMS!

please help

Lex