I have a db with several tabs. I added a new tab to search a related table that does NOT delete the records if the other related table records are deleted. I want to be able to search this table independently of the related table, however, if the related table has deleted the file is not found. The record still exists in the related table though. Can this be done or am I spinning my wheels?