Dave,

>Where do you put a check for duplicates before posting a new record?

I would put the checking in a business rule object. Business rules are checked before any transactions are started so you can bail out in a clean manner.

Regards,