Hello everyone! A few friends of mine and I have been working on an inventory and sales management tool for a game we play. We're having some difficulty due to our inexperience with Microsoft Access and the unique tracking and inventory distribution we're trying to implement and manage.
To clarify what we're doing: We're playing an MMORPG that has groups consisting of multiple players to attend an event to generate items that can be sold for gold. We'd like to track the group attendance and the items sold for gold, and associate the gold earned with each player as unique player accounts, as well as a total guild bank account. We want to be able to associate the item sales with each event/player in order to track their accumulated donations as well as what they are owed. We're trying to create an accountable and transparent foundation for our guild and its members.
Here is the process in which we'd like to track:
1: Log the players that attends an event.
2: Log the item(s)generated from that event.
3. Log player decision to donate their share to guild bank or keep for themselves (split).
4: Log the sales for guild bank items.
Ideally, we'd like this all to be automated, where the only manually entries would be the steps listed above: Event/Participants, Items, Donate/Split (per player), Sales.
Any support is greatly appreciated! Thank you so much for any consideration!
To clarify what we're doing: We're playing an MMORPG that has groups consisting of multiple players to attend an event to generate items that can be sold for gold. We'd like to track the group attendance and the items sold for gold, and associate the gold earned with each player as unique player accounts, as well as a total guild bank account. We want to be able to associate the item sales with each event/player in order to track their accumulated donations as well as what they are owed. We're trying to create an accountable and transparent foundation for our guild and its members.
Here is the process in which we'd like to track:
1: Log the players that attends an event.
2: Log the item(s)generated from that event.
3. Log player decision to donate their share to guild bank or keep for themselves (split).
4: Log the sales for guild bank items.
Ideally, we'd like this all to be automated, where the only manually entries would be the steps listed above: Event/Participants, Items, Donate/Split (per player), Sales.
Any support is greatly appreciated! Thank you so much for any consideration!