Im trying to create a report in crystal reports that interfaces with LDRPS (sungard).  Im having difficulties with linking tables; the output displays the wrong data. The output gives numbers rather than text. The field it is pulling from is a pkfrom table.  Troubleshooting - Created a LV_pickfromlist, however the field the data is pulling from is a custom pk from table, not a list.  I tried connecting a pkfrom list and it still shows numbers.  - Links are outer joined.  Tables are primary to lookup tables. annlindgren@comcast.net URGENT!