Hi Marion,

We can add that item to the View for you. When creating the composite tables, we chose to expose only those fields we thought were most likely to be used, in order to help the problem of "field choice overload". I'll try and make sure it's included in the next service pack for GridView. You might also onsider creating a View showing the specific information fields you need from that table, and linking to it from the first View. (This workaround works if you are not trying to filter on the Vendor Item Number.)

As a general rule, Crystal Reports for Adagio has all the fields in all the tables exposed and linkable. It is the reporting tool of choice when presentation is important and speed is less of an issue.

OK?
_________________________
Andrew Bates