Table Relations

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

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: