• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 6. Creating Relationships > Creating a Lookup with a Self-Relationship

Creating a Lookup with a Self-Relationship

By using a self-relationship to do a lookup, you can save yourself lots of repetitive input and decrease typing errors. Many types of information, like a Zip code and the city and state combination it represents, must always be the same. If you use the most specific information (in this case, the Zip code) to define the relationship, you can automatically insert the other two fields' contents.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint