Gossamer Forum
Home : Products : DBMan : Customization :

Modify Field in relational database

Quote Reply
Modify Field in relational database
Hi,

I have a fairly simple problem which I cannot seem to solve on my own. I have a relational database following JPDeni's relational model. In my user database, I have a field called 'Count', which for each user, keeps a count of the number of items added by that user. Simply put, how can I increment the 'Count' field of a user in my users database when I add a new record to the items database, and how can I decrement the 'Count' field of a user in my users database when I delete an item from the items database?

Thanks in advance,
Jonathan