2007 Jun 27 10:30 AM
hi,
what r the pre requisites for foreign keys
2007 Jun 27 11:12 AM
HI
1.TABLES WHAT U R GOING TO LINK SHOULD HAVE COMMON FIELD.
2.IN CHECK TABLE THAT COMMON FIELD SHOULD BE PRIMARY KEY.(BUT CHECK TABLE CAN HAVE MORE THAN ONE PRIMARY KEY).
3.IN TRANSACTION TABLE IT NEED NOT BE A PRIMARY KEY.
REWARD IF USEFUL.
2007 Jun 27 10:33 AM
HI,
TWO INTER LINK TWO DATA BASE TABLES THEY MUST HAVE COMMAN FIELD WITH COMMAN DOMAIN AND IN THE CHECK TABLE THE CHECK FIELD MUST BE THE PRIMARY KEY
2007 Jun 27 12:50 PM
Please correct if i am wrong.
1. The name of the field in the DB tables can differ, But both of them MUST refer to the same domain.
Regards,
Goutham.
Bluesky
