topic problem in foreign key relationship.. in Application Development and Automation Discussions

problem in foreign key relationship..

Former Member — Mon, 23 Nov 2009 06:50:26 GMT

Hi All,

I have created 2 table. First is Ztab1 which is check table and second is Ztab2 as foreign key table.

I have created couple of nonprimary key fields in table Ztab2 as foreign key fields, i want to know can i create primary key field in table Ztab2 as foreign key field.

And after creation of foreign key table, i want to know if i'll delete any record from table Ztab1 then should the same record be deleted automatically from table Ztab2 ?

Thnx.

Re: problem in foreign key relationship..

kesavadas_thekkillath — Mon, 23 Nov 2009 06:54:34 GMT

It wont delete automatically.

Try to keep some deletion indicator in your primary table and update it.

Use maintenance view for data manipulation

Re: problem in foreign key relationship..

I355602 — Mon, 23 Nov 2009 07:10:49 GMT

Hi,

Yes you can keep the primary key fields of ZTAB2 as a part of foreign keys.

And if you delete records from table ZTAB1, then the records from table ZTAB2 won't be deleted automatically.

Instead, you will not be able to delete those records from ZTAB1 because of the foreign key relationship.

For the you need to first delete the records from table ZTAB2 and then delete from ZTAB1.

Hope this helps you.

Regards,

Tarun

Re: problem in foreign key relationship..

Former Member — Mon, 23 Nov 2009 07:11:18 GMT

Thanks for ur reply

Can u please tell me how to set deletion indicator in table ...

can please answer my first questions also

Re: problem in foreign key relationship..

Former Member — Mon, 23 Nov 2009 07:13:16 GMT

Hi,

Yes you can delete the entry from check table but it wont get deleted from foreign key table. I suggest you create maintainence view for both.

Go through below blog, it will clear your doubt:-

[;

Regards

Abhii

Re: problem in foreign key relationship..

kesavadas_thekkillath — Mon, 23 Nov 2009 07:14:33 GMT

Hi,

Tarun has answered your question.

Just put a new field as like MARA-LVORM.

and when deleting just mark it with a value say 'D' .

so while picking data just ignore where deletion indicator is 'D'.