Need to build drop-down list based on query of past records
We serve the homeless. A client can request many resources, but some resources are limited on how often you can get that item. For example, you can only receive shoes or a blanket once every month.
A contact table -> interaction table -> resource requests table -> resources table
When a client visits today (interaction) he may request certain resources. We want to limit the resources he can request based on his previous history.
Also, how do we keep a client from requesting the same resource twice on the same interaction?