|
Lookups |
  
|
|
Lookups |
|
| • | Parent File: If you would like this to have a different parent file than the default, choose it here. See the Note on Parent Files to see what a parent file is. |
| • | File Name: The name of the file to do the lookup on. Only files related to this item's parent file in a one to many relationship will appear in this dropdown. |
| • | Linking Fields: This only appears if the Parent File is set to None. This allows you to do a lookup based on a custom relationship between files. What is required here is an expression that links up to three fields in the Lookup file to corresponding fields in the parent file. In other words, supposing the parent file is Ranges and the file to do the lookup on is Networks, it needs to have the following format: |
RAN:NetworkCode = NET:NetworkCode
You also need to make sure that there is a key in the Lookup file that contains each of the lookup fields used in the expression. Otherwise, the lookup will not work.