I feel like there is an easy way to do this, but I don’t know how to describe it, so I’m having trouble searching…
I have one table with a list of lessons. The first field is lessons to be presented.
A second field links to a table of individuals who need to be given lessons, so it looks like this:
I would like to have an auto-populated second table (or view) which creates a to-do list with the first field being the following format: “Student’s Name: Task”, with one record generated for each individual receiving that task, so it might be:
CK: Folding Cloths
Rogers: Folding Cloths
How do I do this? Your help is much appreciated!