1 Reply Latest reply on Oct 25, 2010 9:43 AM by philmodjunk

    creating inventory and order database from product list

    TimRogers

      Title

      creating inventory and order database from product list

      Post

      first my apologies if this is in here somewhere. but I am just newto filemaker, am learning it and am using it for my business....which is a bar. so, i've created a liquor inventory list that, basically, looks like:

      PRODUCT NAME | PRODUCT ID NUMBER | PRICE
      ========================================
      product name 1   | 1234                              | $19.99
      ------------------------------------------------------------------------
      product name 2   | 4567                              | $21.99
      ------------------------------------------------------------------------
      etc...

      i want to use my list of productsto create both inventory and prder lists that are also stored as a database... so....inventory databasewould like:

      DATE      | PRODUCT NAME 1 | PRODUCT NAME 2 | ETC....
      ===========================================
      January   | 5                             | 7                              | ...
      -----------------------------------------------------------------------------
      February | 8                             | 3                              | ...
      -----------------------------------------------------------------------------
      etc...

      Am I making any sense? Is this doable?

      Anyone's help would be greatly appreciated. Thanks

        • 1. Re: creating inventory and order database from product list
          philmodjunk

          While doable, listing each product in a different column is much more difficult to do in FileMaker. Since you are new to the game, you might want to set up a summary type report that looks like this:

          January 2010
              Product 1     5
              Product 2     7
              Etc...

          February 2010
               Product 1    8
               Product 2    3

          This format is much easier to set up in a FileMaker database.