Inherintly POOR legacy design from 3 1/2 years ago. I was hoping to rebuild the app to use VIEWS now that they are more stable than VFP3 when I started this project. I am looking at redesigning to use a Surrogate keys but it will be a task in a half at the moment.