AnsweredAssumed Answered

Help modifying Asset Management db

Question asked by dravk05 on Jan 4, 2012
Latest reply on Jan 4, 2012 by philmodjunk


Help modifying Asset Management db


I'm hoping to get some help in modifying the Asset Management db that's provided with Filemaker Pro. I've removed the appreciation/depreciation tabs and just have the 'loaned to' tab at the bottom with the top still original.

Ideally what I'd like to do is have the 'loaned to' be not just a one off but a running list. So you can see, at a glance, how many times an item has been checked out with the most recent at the top. The layout would be asset information at the top and then all records of loaning be listed below, most recent at the top.

I'm not sure of the easiest way to go about this. 

Is it easier to create a second database for the 'loaned to' information and then have it display in the original Asset Management db? Or can I achieve what I want with just one db? Creating a new record would create new loaned to information rather than new assets. However there is always the opportunity to add more assets down the road.

It's been a few years since I've worked in FM and any help would be greatly appreciated.

Thank you!

(FM Pro 11, Mac OS version, 10.6.8)