X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
   Reply to this topicStart new topic
> Cannot Reference Rows, Any Versions    
post Apr 5 2020, 07:10 AM

Posts: 770
Joined: 20-October 05

I'm using O365 Sharepoint (SP) lists within Access and got the below error when trying to set a form control with a foreign key (fk)

You cannot reference rows created when you are disconnected from the server because this violates the lookup settings defined for this table or list. Please reconnect all tables with the server and try again.

I read this

but don't quite understand. I have a 1:M relationship between tblNewJob and Metro_CS (image below) and just want to set the fk. I initially setup the table in Access, uploaded to Sharepoint, linked the List, then setup the relationship within Sharepoint (I don't know if this has anything to do with it). The 2nd screenshot shows that SP has issues. Any thoughts, please? Lex

Attached File  2020_04_05_8_06_58.jpg ( 159.02K )Number of downloads: 6

Attached File  2020_04_05_8_22_49.jpg ( 61.32K )Number of downloads: 4

This post has been edited by lex: Apr 5 2020, 07:25 AM
Go to the top of the page

Custom Search

RSSSearch   Top   Lo-Fi    2nd July 2020 - 01:38 PM