ugh... my issue is too complicated!
When I assign a detention... I want to tell the form that I assigned a detention and I want the kids name, the issue date, and the opened date to automatically appear in another table.
after the kid serves the detention, I want to be able to go into that...