Table level mainly 3 types of relations there…..
1)normal 2)fieldfixed 3)related fieldfixed
Normal:::To specify the relation fields without any conditions…
Fieldfixed:::To specify the relation fields to restrict the records in the” primary table”..[Means first table]
Related Fieldfixed:::To specify the relation fields to restrict the records in the “related table”….[Means Related table]
ForExample: take two tables…Custtable having Accno,Name,Gender[male,female---- male means 0 female means 1] [primary table]
CustTranse having Accno,Transdate,Amount,Paid [ yes or no-----yes means 0 no means1] this is related table
Normal—–Custtable.Accno==CustTranse .Accno
Fieldfixed—- Custtable.Gender == 0
Related Fieldfixed—- 1 == CustTranse .paid
No comments:
Post a Comment