Search results

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...

No unfortunately it won't let me it says it is related to other records

The relationships are correct I just want to get rid of one of the records the records are added everyday

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...