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

Chapter 6. Creating Relationships > Lookup vs. Related Fields

Lookup vs. Related Fields

Once you've established a relationship between files, you can choose between two methods for using the source file data. With the first method, you use the Lookup function to copy the actual data from a field in the source file to a field in the receiver file. Alternatively, you can display the source file data directly by placing its fields on a layout (or using them in a calculation) in the receiver file.

If you choose Lookup, when you enter a value in the source file's match field, the data in the specified fields is copied into fields in the receiver file. Once you've copied the files, however, if the data in the source changes, the data in the receiver file won't update. This might be useful if, for example, you want to maintain the customer's shipping address at the time of the sale.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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