I seem to have lost my brain today and cannot figure out how to do this. I have 2 tables, positions & tasks. There is a need to specify if a task is valid for a position. This is a many-to-many relationship creating a 3rd table of position & task & valid y/n. So far so good.
On a screen I need to show the task as the row, the position as the header and the valid y/n field as the intersection. The user needs to be able to update the y/n field. (They have different screens for adding positions and tasks). So, how do I do this? All of the cross-tab writeups reference a calculation as the intersection. And I don't need to add.
Anybody have an help for me? Tks.
On a screen I need to show the task as the row, the position as the header and the valid y/n field as the intersection. The user needs to be able to update the y/n field. (They have different screens for adding positions and tasks). So, how do I do this? All of the cross-tab writeups reference a calculation as the intersection. And I don't need to add.
Anybody have an help for me? Tks.
