Some help with a specific requirement
I am trying to build a membership database, and attached to each member I would like a field that tells me the date and time they used their weekly "once a week freebie".
Not sure which field type I should use and if I have to make 52 individual fields (table) that's attached to each user.
I would basically like to track when they come out and know that we are not giving them more than one a week. I would also love to get a report that would show me both a single users weekly usage or all my members usage. So the field set up would need to be done a certain way I guess?
Thanks for any advice or resources you could help with me.