LookupTable Collection Object

OutlineCode LookupTable LookupTableEntry

Represents a lookup table in Project. The LookupTableEntry object is a member of the LookupTable collection.

Using the LookupTable Object

The following example adds three level entries to a lookup table, where the third level entry is set with three values.

Sub EditLocationLookupTable(objLookupTable As LookupTable)

    Dim objStateEntry As LookupTableEntry
    Dim objCountyEntry As LookupTableEntry
    Dim objCityEntry As LookupTableEntry
    
    Set objStateEntry = objLookupTable.AddChild("WA")
    objStateEntry.Description = "Washington"
    
    Set objCountyEntry = objLookupTable.AddChild("KING", _
        objStateEntry.UniqueID)
    objCountyEntry.Description = "King County"
    
    Set objCityEntry = objLookupTable.AddChild("SEA", _
        objCountyEntry.UniqueID)
    objCityEntry.Description = "Seattle"
    
    Set objCityEntry = objLookupTable.AddChild("RED", _
        objCountyEntry.UniqueID)
    objCityEntry.Description = "Redmond"
    
    Set objCityEntry = objLookupTable.AddChild("KIR", _
        objCountyEntry.UniqueID)
    objCityEntry.Description = "Kirkland"
End Sub

Using the LookupTable Collection Object

Use the LookupTable property to return a LookupTable collection.

Properties | Application Property | Count Property | Item Property | Parent Property

Methods | AddChild Method

Parent Objects | OutlineCode Object, OutlineCodes Collection Object

Child Objects | LookupTableEntry Object

See Also | LookupTable Property | LookUpTableAdd Method | OnlyLookUpTableCodes Property