Kris,
Happy to have your help your help and suggestions.
Kristine wrote: not sure of your IT/programming skills), or I will be able to create this for you from scratch.
Just a beginner; only been doing A/P work for about 20 years (7 of those in the USofA) and an invited speaker at international conferences in Eu, US and Au for about 10 of those.
In all seriousness, I'm going to see if there's an existing add-on for PHPBB first. No need to reinvent the wheel.
Failing that, creating an add-on seems to me th be the way to go, because it's already handling the major issues of security and satabase access.
Off the top of my head, I'm thinking in terms of a simple table, creating a many-to-one relationship with the users' table here. That table would contain fields for serial no, phpbb user no, descritpion of asset, date acquired, price paid, and current status (owned, stolen, etc),
What have I forgotten?
What other suggestions are forthcoming?