button to delete records

[kgcrowther]

I've created a form for updating a list of engineers. (This list is used on another form so that spelling of engineers names are always consistent.)

On the form there are two buttons. One for adding a new engineer and the other for deleting one. However, when the user deletes an engineer from the list I have to go through and locate all the records in which that engineer is included and delete them. It seems like Access should be able to do it, but I just a summer intern and don't know much about VB.

Any help is great.

[This message has been edited by kgcrowther (edited 06-05-2001).]

 

[Rich]

You need to link your tables correctly and allow cascading deletes.

 

[kgcrowther]

That's what I needed to know. Thank you!