PDA

Click to See Complete Forum and Search --> : VB6,SQL7,FK Constraint


lotfranaei
Jan 22nd, 2000, 04:13 PM
Hi,
I am using the diagrams to add some FK Constraints. The parent Table PK is an identity field and should be incremented, wenn a row is added. At the Time wenn I am adding the row in the parent Table, I want to add a corresponding row in the child Table. Is that a way to get the PK field value directly in the child Table FK field?
Thanks

Clunietp
Jan 23rd, 2000, 03:18 AM
Use a trigger, examples here:
http://www.vb-world.net/ubb/Forum3/HTML/002723.html