When using begintrans, getting a foreign key error on insertion

please see the thread on

http://www.vbforums.com/showthread.p...87#post3228887

i am using vb.net

Please don't cross post.