Thanks for your response firstly, have asked around the company and got nowhere.
So, if this forum actually allowed more formatting, it might have been clearer what I am trying to achieve.
We have a site tree along the lines of:
What the ask from the client is, is to have a single page, sitting under the Locations node, that will list out all of the locations (200 or so of them), in the backend of the system only, and for each of the locations to have some additional field for them to enter.
This listing would need to look something like
Which then when I am building the location page for the frontend. I go off and look at this single page in the CMS, find the location and pull in the additional fields and do the rest of the clients request. As this is sort of a data structure, this is why I was looking at the custom table, but didn't really want to go down that route