In simple terms:
I have db local on my machine and several others I work on.
All my tables are then linked to Sharepoint site so that the data is a) Secure and B) accessible from all machines with live information.
The problem I am having is for example with my tblcontacts and frmcontacts.
Now when I try and change some information through the form like a telephone number I get the message saying the change will break a data integrity rule and wont let me save my changes.
I cant understand what has changed within that table or form. I have made no changes to either table or form only to other tables and forms within the db.
I do have a drop down box with a list of my contacts (so source would be tblcontacts) in several forms but still dont understand what causes the integrity issue.
My knowledge is basic should I have done something different?
Thanks
I have db local on my machine and several others I work on.
All my tables are then linked to Sharepoint site so that the data is a) Secure and B) accessible from all machines with live information.
The problem I am having is for example with my tblcontacts and frmcontacts.
Now when I try and change some information through the form like a telephone number I get the message saying the change will break a data integrity rule and wont let me save my changes.
I cant understand what has changed within that table or form. I have made no changes to either table or form only to other tables and forms within the db.
I do have a drop down box with a list of my contacts (so source would be tblcontacts) in several forms but still dont understand what causes the integrity issue.
My knowledge is basic should I have done something different?
Thanks