Hi all, I am currently trying to create a database that contains a user's total points from what items they have submitted using my form to my item database. I'm trying to figure out how to:
1.) have my two databases connected so when a user enters an item into the database, they get points for it in the user points database, but if they remove it it removes the correct amount of points from the user points database,
2.) have the submit button on click check if the user has an entry in the user points database and if they don't create one,
3.) update their points in the points database if they do have an entry instead of making a bunch of new entries to save storage space.
I want these to be separate because I don't want a new entry in the points database for each time a user submits an item and I just want it updated to their new user points value, but I do want each item to be a new record in my items collection since each one has a description and image with the item.