Sorry, but I am new to Access so it takes a while to sink in
So this is what I did:
Took each relationship that was connected deleted the line so there was no relationship.
Went into each table that had the info
deleted the record.
Re-established the relationship. And everything seems okay...
The record was actually the last record entered- an ID number was wrong
I want to delete the record and recreate it same infor just a different ID number.
Why I want to delete a relationship
When I try to delete the record I get a message
The record cannot be deleted because the table 'SampData' includes related records.
So I thought if I delete the relationship I can delete the record from both tables. Re-establish the relationship - and then...
I want to delete a relationship temporarily so that I can delete a record. After the record is deleted I will restore the relationship immediately. But I am concerned that this will ruin any queries I have already established or ruin my other records.
Could you let me know if this is possible...