Lookup field description

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • mouac01@yahoo.com

    Lookup field description

    I have 2 tables. One is a data table and one is a data dictionary. Is
    it possible to join the 2 tables and display the description from the
    data dictionary instead of the field name from the data table?
    Thanks...

    Data table:
    fld1 fld2 fld3
    10 20 30
    40 50 60

    Data Dictionary:
    name description
    fld1 field 1
    fld2 field 2
    fld3 field 3

    I want:
    field 1 field 2 field 3
    10 20 30
    40 50 60
Working...