Combine two LinkFields in one column?

I am building a very simple report on the names our Vendors and Customers have for our items. (Basically the Item Cross Reference Table with a few other tables for names and descriptions). I would like to have the name of the company in a single column, regardless of whether they are a Vendor or Customer. Is there a way to combine the columns in Question? In the file, they are columns I and J.

Thanks for any help. Also, if there is a support article on this for relative newbies, I'd appreciate the url(s).


Please sign in to leave a comment.