I am convinced that your instinct was the right way to go. I can associate with this scenario,

Particularly if the developers are only on site for a short while and...

Hi,reading between the lines, i expect you are eventually going to need to combine a select statement from each of the tables. I have created a mock up of what...

Dont expect that was a exceptionally difficult problem and assume that as I am new to the DBA work, I need to work on the phrasing of my questions 🙂

Anyway,...