topic Re: Create foreign key in Application Development and Automation Discussions

Create foreign key

Former Member — Sun, 28 Jun 2009 15:21:38 GMT

HI ,

I have 3 tables that related to user

1. user table

2. user address (can be more then one entry per specific user)

3. user additional data (can be more then one entry per specific user)

in case that i delete the user in user tables all the data on the related table need

to delete also.

do i need to create foreign key for that issue?

Can any one guide me how to create foreign key for this issue?

Best regards

Nina

Re: Create foreign key

Former Member — Sun, 28 Jun 2009 15:43:27 GMT

You must be having a Primary Key for the User Master Data.......You need to assign this Primary Key as the Foreign Key of the Other Two user Tables.

Two assign the Foreign Key in Data Dictionary.....Select the Primary Key of the User Address Table and Click on the Foreign Key button and then assign the Primary Key of the User Master Data table as the Foreign Key for the USer Address Table.

Same is for other Table.

Re: Create foreign key

Former Member — Sun, 28 Jun 2009 20:54:42 GMT

HI AJAY ,

Thanks,

Since i am going to do that at first time can u please guide me how to do that step by step,

or send link that can provide more data how to do so.

Thanks

Nina

Re: Create foreign key

Former Member — Mon, 29 Jun 2009 03:14:37 GMT

Hi Nina,

Check this link

[;

Regards,

Sakthi Sri.