1 Reply Latest reply on Oct 12, 2009 10:17 AM by philmodjunk

    lending library-boxed set loans



      lending library-boxed set loans


      I am using filemaker pro 10

      mac OS 10.5.8 


      I have used the filemake 'lending library template' to biuld my own lending library.

      I have approx 200 assets and 100 contacts

      In most cases I lend 1 or more assets to 1 contact. This is working well.


      I would like to add the ability to loan 1 item that has multiple assets assigned to it.


      Most times assets are loaned as single items but at other times I need assets to be loaned as a boxed set.

      I am hoping to achieve this with a single loan that groups the assets (instead of making say 6 loans to a contact)

      I need ability to loan items as both single assets and as boxed set.


      example: one day - loan 'electric drill No1'  

      next day - loan 'electric drill with 6 specialist attachments' 

      the drill and six attachments all exist as separate assets (total of 7 assets in my assets list) 


      This seems complicated to me. 


      I think it requires a script but I am not sure where to start.

      At check out - 

      It would need to check which items are in the boxed set.

      Check if items are available or not available (status field)

      Place available boxed set items in a field that is recorded with the loan.

      change the status of assets loaned in the boxed set.


      At check in -

      change status of assets in boxed set



      thankyou in advance to anyone who can help.

        • 1. Re: lending library-boxed set loans

          Check out some of the threads here that deal with invoicing. (click the advanced tab and search for invoicing as a keyword.)


          With invoicing, you normally have one record that represents a sales transaction, (in your case that would be a loan), with multiple items listed on the invoice (just like multiple items listed in your loan.) This is accomplished with two tables. Table 1, 1 record for each loan (invoice record for sales), Table 2, one record for each item, (often called a LineItem table.) You link the tables by an auto-entered serial ID field in Table 1 and enable the creation of related records in table via the relationship. Final step, place a portal on a layout to record each loan that lists the related line item records so that you can itemize what's being loaned out.