Create foreign key

[Former Member]

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

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi Nina,

Check this link

[;

Regards,

Sakthi Sri.