Inventory management with FMP 9
I'm new here on the forums and with FMP, I just started working with it last week. I was put in charge of updating an existing database for an inventory. Most of the FMP database has been complete for almost a year but it has never really been used by the employees (the inventory is used by an engineering department for their own projects, not for customers). I was brainstorming some additional ideas to make it more enticing to use the FMP database rather than just looking for the parts on their own. The items in the inventory mainly consists of tubing of various diameters with the largest no larger than a half-inch in diameter. The entire inventory consists of about 1000 different items.
Is it possible to incorporate pictures of the parts as part of a form/report? How difficult would it be to publish the database on a website? I was also thinking about possibly using a barcode system to track the inventory, do you guys think that would make much sense with smaller items, and a relatively small number of them? Mainly I need to bridge the gap from paper to computer, and I need some ideas to help convince some of the older employees to use the database rather than spending extra time searching for the parts.
I will be meeting with a FMP whiz in a few months in order to further develop the database, but I would like to get a jump start now so when I meet with the specialist we can focus on more advanced things.
Thanks in advance!