How to Stop MS Access From Undesired Cascading Delete?

When I delete a record from one Microsoft Access table, it deletes the corresponding record in another table. I need to stop that. 1. Table 'items' has ID (the key), item_name, and some other fields. 2. Table 'special_order_item' has 'item' (the key), quantity, and some other fields. 3. special_order_item.item is an Access Lookup field, with Row Source: ID, item_name FROM items; There is no relationship between the tables defined in Access. The apparent cascaded delete happens only when I use the GUI to select the record in special_order_items and press the Delete key. If I enter and run a SQL delete statement, the record is deleted from 'special_order_items' without impacting 'items'. It happens only when the Row Source is a SQL query (e.g. a SELECT statement); not when the row source is a table. My intent is that a special_order_items record must have an 'item' drawn from items. 'items' is my list of things which can be special-ordered. Deleting a special-order should not delete the item from the orderables - just from special-order.