Forum Discussion
relations
Hi, I've two tabels: Employee Consult and Scanvragen MC. In the tabel Employee Consult are colomns with questionscores. The name of the colomn is the code of te question. The questions with the ...
jaspijk ,The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
thansks for your quick reply!
In tehe first tabel You see the colomns ECCO001, ECCO002, ECCO003, ....... The colomn-names are corespondending with a field in he second table 'vraagcode'. I want tot use 'vraagtekst' from the second table as the colomnames of the first to report the results. So instead of reporting ECCO001 with the everagescore of 89, I want to report the corrrespondeding text woth tehe score.
Now I get:
And I want:
'Dat de organisatie een duidelijke visie heeft' (text in the second table)
89