Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

creating foriegnkey relationship

Former Member
0 Likes
713

hi

how to create foriegnkey relationships in database tables. se11.

regds

venky

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
689

select the field on which to create a foriegn key than , above there is a button with a KEY icon on it press it, it will ask you if it should propose a relationship, press yes, check if it is right and press ok.

Regards,

Khusro Habib

hi

how to create foriegnkey relationships in database tables. se11.

regds

venky

3 REPLIES 3
Read only

Former Member
0 Likes
690

select the field on which to create a foriegn key than , above there is a button with a KEY icon on it press it, it will ask you if it should propose a relationship, press yes, check if it is right and press ok.

Regards,

Khusro Habib

Read only

Former Member
0 Likes
689

Just select the keyfield for which you you want to specify foreign key(key button which is near to searchhelp button click on that , there you can specify the details..

vijay

Read only

Former Member
0 Likes
689

Hi,

Goto se11. select the field for which you want to create a foreign key. Click the foreign key button, located on the immediate left of search help button. Provide the check table and click on generate proposal. The system will generate a foreign key proposal for you. You can use the same Or else you can create a proposal on your own...

Hope this helps...

Lokesh

Pls. reward appropriate points

Message was edited by: Lokesh Aggarwal