Added a Field (1 Viewer)

[thingssocomplex]

I added a field on an existing form from a different table, Access prompted me to create the relationship which I did and everything worked like clockwork and the new field appeared. However I have now lost the ability to change or add new records (simply greyed out) checked property setting and they are correct. I removed the newly added field but this did not help how do I overcome this issue?

 

[thingssocomplex]

I have managed to get back to earlier verions from a restore point and I am now work on a copy of the database. I have a contacts table and I need to add the email address to the form (from the master table) when I select it from the contacts table I lose the ability to add a new record, how do I overcome this please?

 

[joemach]

Question; why is the email address in another table than the contacts table? That email address can only belong to one contact, correct?