What I'm looking to do is set up an inventory control object.
If you use the online Library demo on the web page and select the "operator" log in you can see two screens related to what can be borrowed. One is the actual item that only allows the setting of "Available - yes/no". The other is item types that shows a column of the maximum loans of that type any member may have.
I can see the rule that uses the COUNT function to determine if a member has exceeded the max number of loans of a type.
I would like to use attributes that maintain how many of a given title exist, how many are out on loan, and how many remain on hand i.e. total that exist less total on loan. When the on hand amount goes to zero I would set the available attribute to "no". I would like the number on loan and number available to adjust dynamically as items are loaned and returned.
I see in the "Rules" manual "INCREASE" and "REDUCE" functions but I'm not at all sure where or how to use them. The examples look like VB code. Would this be done in the "Text" window of the rules dialog?
If you can point me to an example or explain how that would be accomplished in the Library sample I'd be off and running.
Thank you for listening
