Hi,
Racking brains on how to do this... Hoping so one here can help.
I am Creating a skills matrix. Now, I realise I could have created a simple data table with a column for the users then columns for each of the skills... It would make what I'm about to ask easy. I did not do this... Becasue my list of skills is dynamic... I want users to be able to add/remove skills through the app, without having to create columns, then update the app to show the columns in the right place etc.
So the structure i went for is to have 2 columns...a user table with an ID that links to a skills table with column for the id (linked to user table) of the user... The skill... And the users level in that skill.
What i am now trying to do is to create a gallery that shows the live users horizontally across the top... With the skills listed vertically below them.
But with my table set up I can not get my head around how to do this?
Any ideas?

Report
All responses (
Answers (