Display lookup value based on foreign-key in bindingsource?

A facade property is the easiest option - especially if it is readonly; just add a property (in a partial class if the type is generated) that walks the relation. There are other routes, though. You can write a TypeConverter and decorate the property with it; this is a pain for generated types, though (since you can't add an attribute to a member declared in a separate partial class file).

You can also use custom property models ( ICustomTypeDescriptor TypeDescriptionProvider ), but these would be massively overkill just for this.

Yep, like Marc said, add a PetTypeName property to the Pet class, which queries the database (or whatever, I'm assuming database) and gets the PetType record from the PetTypeID.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.