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
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