So, I would like to use LibreOffice Database as a roster. I need to keep track of everyone who shows up on any given day.
However, I think it would be cumbersome to go about a field with 200 rows each holding a date that someone showed up. Is there any other way to do this? (Ie, query to actually add a column every time someone shows up?)
This database needs to be searchable too… it needs to show everyone who showed up on a certain day, or search to see if someone specific did or didn’t show up on a different day. (So n…n queries I guess.)
I’m not sure how to design this database, I’d be grateful for any help.