I am creating a very basic set of forms and reports to track a pet food pantry program. Our animal rescue supplies free dog and cat food to those in our community who are unable to afford.
I have a form that tracks their information and then a form that we enter when they pickup which has a lookup so we can tie it to the person (customer).
Two seperate questions:
1) Is there a way on the pickup form that we can have it automatically indicate in a field the last time they picked up food?
2) On the customer information form, can we display their pickup history?