Field entry in a relation: when entries get deleted question
What is it that determines whether an entry in one table/field will be deleted in the relational main table's field?
I have the typical relational link from the first table (the ID field) to a second table (its ID field) in order to get that drop down list where I can pick a record's info and have it automatically entered in the second table. This works well. I was using this to enter fields in the second table for testing purposes, which would be temporary. I noticed when I highlighted the field and deleted the text that had been entered (because I was just messing around), it deleted that info in the main table too. When I checked the relationship, I do not have the "delete related records in this table when the record is deleted in the other table" or the "allow creation of records in this table" checked. Is this happening merely by the link from ID Table 1 to ID table 2?
Is there any way to stop this behavior, or just stop testing it out this way!!