Possible to create an Expression column that reaches back through several relations?

With a complex normalized database structure using surrogate PKs, sometimes
to get a string name value, it's necessary to reach back through several
PK-FK relationships. What I'd like to do is add a customer name to some
datagridviews that are far down the sales process without setting up some
messy great-grandchild relationships. Both Sceppa and Malik have excellent
info in their books on how to handle the typical parent-child situations,
but I've not seen anything in print on this topic. Anyone?


.

Loading