AnsweredAssumed Answered

Need to build drop-down list based on query of past records

Question asked by ourcalling on May 22, 2012
Latest reply on May 30, 2012 by philmodjunk

Title

Need to build drop-down list based on query of past records

Post

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. 

thoughts?

Also, how do we keep a client from requesting the same resource twice on the same interaction?

Outcomes