1 Reply Latest reply on Nov 4, 2010 8:21 AM by disabled_JackRodgers

    Equipment Usage Database, tied to list of loanees

    JamesClark

      Title

      Equipment Usage Database, tied to list of loanees

      Post

      I'm new to using filemaker and I've started off with a project of building a database of equipment used by the production company I'm working for, as of today I have it doing pretty much everything I want it to do, it presents information about pieces of equipment and also how many of a given asset is currently in stock or in use it also records the date of the last time someone borrowed a piece of equipment and the date when the last person returned a piece of equipment.

      What I'd like to do next is to have a person accessing the database enter their name every time they borrow a piece of equipment and to have that name and the recorded date be added to a list of separate occasions when the equipment was borrowed, how much of it and by whom. This way the database as it currently stands can give the basic information of when something was last borrowed and last returned but also if need be one can look at a more detailed and comprehensive list with details of all the previous borrowing. This will also be necessary as we have several of certain pieces of equipment so if someone were to borrow say 2 out of 6 of one of them and then later another user borrows 1 the database will currently only display the date borrowed for the latest occasion where something was borrowed. This is okay but I want to be able to build this more detailed list so that if one needs to, they can track where the other two are and how long they've been gone.

      Can anyone tell me how I would go about setting this up? Do need to create a record for each occasion of borrowing? Or is there some way to set up a record which is just a list of multiple data entries for each time something was borrowed? Which would be best?

        • 1. Re: Equipment Usage Database, tied to list of loanees

          You should study portals and relationships. Check the help file or examples in Filemaker's free files.

          One idea is to establish a relationship between employees and equipment based on the employee id. Now you can create a portal on a form in both files showing the related records in the other file. After you get this working you can move to the next step.

          Employe:

          ID Emloyee  ( a number field set to auto-enter)

          Equipment

          ID Equipment ( a number field set to auto-enter)

          ID employee  ... the field used to establish the links.