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

  • Thread starter Thread starter Earl
  • Start date Start date
E

Earl

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?
 
What I've preliminarily decided to do is propogate an expression column
4-deep from the Contacts table within the dataset. This looks like the
cleanest solution.
 
Back
Top