In the designer, we have the following tables (not really, but this simplifies it):
Employee, joins to Department.
Department has the field "IsManagement" (yah yah silly)
How do we create a Sub Type called Manager in the designer based on if the IsManagement" is true and the fields all come from Employee.
Basically the discriminator is in another table.
Ian