Unanswered: Is it possible to create a datasheet form that works like a PivotTable
I have a table with three fields:
How can I create a form that has URN as the x-axis, session_ID as the y-axis and current as the data in between. URN will be a unique ID, there will be many session_ID's and current will be a yes/no field (preferably a checkbox).
I have seen that something similar can be done in PivotTable but the crucial thing is that it needs to be possible for the 'current' value to be changed. Is this possible?