I am trying to create a table that will have a subsubdatasheet, and I'm having some trouble. Here is a simplified version of the structure:
One table has a user assigned to a specific role (chosen from a linked table of possible roles). From there, depending on which role they choose, I'd like to have different sub fields. If they choose Role 1, we may have to track data X and Y, but if they choose Role 2, we'll be interested in tracking data A and B.
Is it possible to do something like this? I'm not sure whether I should be using queries or subdatasheets. I hope this all made sense.
Thanks in advance!