Table Relation:
Foreginkey Relation For Example
- First create a new table like Foreginkey table and add a new fields as u want
- And create new ETD as ID and drag into Foreginkey table
- Then create new index for table in the name of ID
- In Index property set alternate key "YES" and allow duplicates "NO"
- Then In Foreginkey table property set primary key as Index name "ID" in lookup
- And then ETD "ID" property set ---> reference table ---> as Foreginkey Table
- Then expand the ETD "ID" right click ----> table reference ---> new table reference and related field as "ID"
- At last if u drag an ETD to any other table it will appear like this
- This is foregin key relation.






No comments:
Post a Comment