physical item tracking.

I would like to be able to track items that have been issued to a member and run a report on the remaining inventory. My example is that we have key (that are numbered and controlled) to a padlock that members are able to receive after providing a deposit. I can easily add a field to hold the key number, but I was hoping to be able to track all keys to include those that have been lost, replaced, or in inventory.

Any advice would be appreciated.

CB has nothing like that. I guess you can accomplish it using CB with a custom database table to keep track of all the keys and who they're assigned to then display them on profile using a CB Query Field. You'd have a database table with something like the below.

id | user_id | key

You'd then assign a key to a user by simply setting the user_id column to their user_id. All of this would have to be managed manually through phpmyadmin or I guess a database management extension for Joomla. Your alternative is to find an extension that provides such usage or develop an extension or CB plugin to provide such usage.

Thank you for a quick reply and appreciate the suggestion.