I am having a problem - someone entered a record on a form that then gets updated or saved/stored on two tables (work order and applications)
i want to delete that record - every time i go to the apps table it is empty (and when I try to delete it it states that the search field is empty. when i try to delete the record from the work order - it tells me that i can not do it - because there is information in the apps table.

how can i do this??

one more thing - when i try to enter data manually in the apps table - it closes access


thanks in advance...