For my site, I have a custom member page. On that page, I want to be able to store transactions that the currently logged in user has placed, but I only want them to be able to see it. Is it possible to automatically create a database for each member on the site based on their member ID or some other unique identifier that only that members information is stored to? An initial collection won't work because I need members to be able to submit as many transactions as they want.
A single database would work as well just so long as users will be able to see the data on their page and that their information will not be stored on anyone elses.
Any help would be greatly appreciated!!