2 Replies Latest reply on Nov 13, 2009 1:01 PM by TSGal

    Inventory control



      Inventory control


      I'm using filemaker 10 on a Mac. I have very little programming skills. I have a drop down box(value list) with different covers that are available on a standard planner. I need to keep a inventory on individual covers. 


      On the same drop down box(value list) I have custom covers and a that uses a different inventory list. I have a total of 40 variables(cover selections and products) .


      Can this be done with a value list? 



        • 1. Re: Inventory control

          This can be done.


          If I understand, you have two inventory lists which I presume are in two separate tables. You wish to create one value list out of these two tables. This requires a third table, a form of link table. It will contain five fields, one link field for each inventory table, one cover name field for each inventory table and one calculation field. The value list will be based on the calculation field.


          Create your relationships so that your inventory tables link to the value list table via their primary key fields. In the layouts of the inventory tables, place the cover name field corresponding to the correct inventory table. When you create inventory records, make sure this is the only place cover names can be entered.


          The last piece of the puzzle: the calculation field. Because each inventory record will create its own related link table record, only one of the two cover name fields will ever be populated. Make sure the result of the calculation field returns the name of the non-blank field.


          Your value list will now display all cover name values.


          I understand this solution may seem really complicated. If this was the case, feel free to contact me by telephone for more help.

          • 2. Re: Inventory control

            David Lalonde:


            I have sent you a private message (top of this page - right side - X Messages).



            FileMaker, Inc.