Asset Management

[lf1991]

Good day everyone,

I am new to this forum, hopefully I have put this in the correct catagory.

I am trying to set up a basic asset management DB using MS Asset management DB template - the standard assets work fine. how ever it doesn't include peripherals at the moment.

I am wanting to add a part to where we can assign peripheral assets to a user. and it takes it out of a pool.

for example,
HDMI cables 1 meter - we would have 10 of them. We then assign 1 cable to a user.

Once assigned it would decrease the amount available in the database and increase the amount assigned.

Would this be possible?

I only have basic knowledge of Access - its been quite some years since I have used it.

 

[theDBguy]

Hi. Welcome to AWF!

Have you looked at the Asset Tracking Database Template available from MS? It might have what you need.

 

[lf1991]

Hi. Welcome to AWF!

Have you looked at the Asset Tracking Database Template available from MS? It might have what you need.

Sorry I forgot to mention - I am using the template from MS, it doesn't really have anything like I am needing. (i'll update the main thread message)

 

[theDBguy]

Sorry I forgot to mention - I am using the template from MS, it doesn't really have anything like I am needing. (i'll update the main thread message)

Hi. Thanks for the update. Can you post a stripped down version of your db, just in case someone can take a look?

 

[lf1991]

Please see attached. I was getting "module not found" error earlier but seemed to have stopped (for now).

Regards
Liam

 

[theDBguy]

Please see attached. I was getting "module not found" error earlier but seemed to have stopped (for now).

Regards
Liam

Hi. Thanks. If Assets can have multiple Peripherals and each Peripheral can belong to multiple Assets, then you would have a many-to-many relationship. If that's the case, you need to add a junction table between Assets and Peripherals to store that information (which Peripherals belong to which Asset).