I'm trying to write to 2 tables with the click of 1 button on a form. The Problem is I want it to only do both 'Insert Into' statements or neither so I don't end up with orphan records.

I'm thinking this can be done with some sort of Batch Transaction my brain is on freeze and I can't remember how to do it.

If someone would e-mail me at cwilkins@ascresorts.com (work e-mail) and cc: chasiv@megalink.net (my home e-mail) it would be GREATLY appreciated.