I need some help on getting information into a report. There are fields from two different tables tied to one data item. I can get the info from the first, but not the second.
I have the Work Code table and Comment Line table both linked to the Item table. I need the work code description and comment. I can see the work code in my table, but not the comment line. If I switch the two, I can see the comment line but not the work code. What is the best way to get this to work?
Answers