Primery key and foregion key

[RTG]

Have a good day

lets assume that i have 2 tables

First one is customer table and has primery key called cusid

second one is order table and has foregion key custid

how i can coonect them , what i mean exactly when insert the record in the customer table i need the foregion key get the same value as primery key in customer table ,,

============
Custid in the customer tabel ( Integer , autoincrement and Primery key )

Custid in order table ( Integer and foregion key )


i want to make relations btw them by using scope identity to make the vlaue in Order table same as in customer table

===================
kindly find my code at attachment


appreciate your help

 

[cjard]

DW3 link in my signature; section: Displaying Related Data