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

Hour 14. Working with Relationships > Using Lookup and LookupNext Functions

Using Lookup and LookupNext Functions

When you have a relationship, you can insert related data into a layout to display it. The Lookup and LookupNext functions let you retrieve that data and massage it.

In the case of Lookup, you specify the related field that you want to retrieve. What is particularly useful about Lookup is that if there is no related record, you can return an error result, as in


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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