I have a join problem I can't figure out.  I have two back-end databases
joined on their control numbers through a front-end query (db2 on the left,
db1 on the right).  No other relationships exist between these tables.  The
control number for db1 is a primary key; the control number for db2 is not.  
Db2 is a very small subset of db1, and the form used to fill in db2 displays
some relevant info from db1.  Users have to manually enter db2 control
numbers; there's no error checking in place, but records should include only
numbers that are already in db1.  The db2 control number is currently set to
index/duplicates okay, because it was originally anticipated that there would
be duplicate records in db2 for each record in db1.  Now I've been asked to
prevent duplicates.  I thought I could simply set the db2 control number to
index/no duplicates.  But when I do that, deleting a record from db2 also
deletes the record from db1 that has the same control number, which I don't
want it to do.  Is it the query relationship that's causing this?  I think
I'm missing something really obvious.