Records as columns in updatable table

[christian85]

Hi,

I have three tables: question, teammember and assignedQuestio ns

A question can be assigned to multiple teammembers, this will be recorded in the assignedQuestio ns table.

What I want now is a list of TeamMembers as columns in a datasheet with the questionnumbers on every row and checkboxes as a value for every cell so that I can assign a question to every teammember. Like this:

_____Member1__M ember2__Member3
Q1
Q2
Q3

I have no idea how to do this, I tried using TRANSFORM (crosstab) but my query isn't updatable

Can you guys help me further?

[NeoPa]

I don't believe this can work as specified. Check out Reasons for a Query to be Non-Updatable.