Roger,
No lynching intended. And your approach is reasonable and is exactly one of the reasons database engines like SQL Server support the concept of views. It's a question of will AC build them and then document them.
And please do understand my point of view. I have been on the phone with a doctor DEMANDING that I find a way to get his data out of an EMR software he had stopped using some time ago but now needed the data from as he was being sued. He had a very difficult time accepting my explanation that there was nothing I could do as the software was online and there was no way to get to the database (the EMR company in question was utterly uncoorperative and even said they had no such account). Since we could not get the data, the doctor lost the case and is now bankrupt. A shame, truly, as he was one seriously good doctor.
JamesNT
.png "ACUF Donor I")
