You Just Identify Them By Using Primary Key and Foriegn Key References
Assume There are Two Tables
TABLE-1 : DEPT (
DEPTID Primary Ke y,DEPTNAME)
TABLE-2: EMP(EMPID Primaty Key,ENAME,SAL,
DEPTID Foriegn Key )
In above Two Tables we Have
DEPTID is Acting as Primary Key and Foriegn Key.....
Total EMPLOYEES are Organized in EMP table with Respective Departments
So Some Transactions Are going in EMP By using Dept Table as a Reference
DEPT is Master Table and EMP-Transaction Table
we will also called as PARENT- CHILD tables even
BangaruBabu Pureti
http://bangarubabupureti.spaces.live.com/
Nav234, if this helps please login to Mark As Answer. | Alert Moderator