3 Replies Latest reply on Feb 2, 2015 9:43 PM by philmodjunk

    The quickest way for an end user to enter values

    Stu412

      Title

      The quickest way for an end user to enter values

      Post

      Not a trick question this one... I have a scenario where end users are required to enter pricing data against 50 or so products which are common across our customers.

      The products are set up in their own table.  I'm wondering what the best way would be allow the users to type in the pricing information quickly and easily.  I'm not going to have them go near an import routine!

      The table where the prices go is not the same as where the descriptions are held (as both can change).

      What would be the best way to 1) List out all the products from table A and 2) allow price updating quickly entering into table B).  Both tables are related

      Thanks

        • 1. Re: The quickest way for an end user to enter values
          philmodjunk

          Listing all the products from table A could be as simple as 'show All records'. But you may not really mean ALL records, but all records for a particular company, which can be done via a single button click or selecting that company from a drop down menu. Either action can perform a script that finds all records. These can be presented in a list view with a field next to each product for recording the new price for that product.

          There are details to this process that depend on your data model--the fields, tables and relationships set up in your database so I can't really provide much more than that without knowing more about your database design.

          • 2. Re: The quickest way for an end user to enter values
            Stu412

            Hi Phil

            The Customers table is linked to the main PriceEntry table which in turn is linked to the Product table.  The Product table is there to provide the list of end product in order to generate the entry list on the layout.  The PriceEntry table exists to accommodate every product's price against every customer.

            So what I'm trying to achieve on the PriceEntry table is something like:

            PKID | ProductIDFK | CustomerIDFK | Price

            1        | 1                 | 1010                | 2.99 

            2        | 2                 | 1010                | 4.50

            3        | 1                 | 1012                | 2.79

            4        | 2                 | 1012                | 4.51

            Hope that makes sense!

            Thanks

            • 3. Re: The quickest way for an end user to enter values
              philmodjunk

              This is a join table linking records in product to records in customers.  A product can have many customers and a customer can have many products.

              So you can set up a portal to PriceEntry on a layout based on Customers. The ProductIDFK field can be setup with a Value list of product ID's and product descriptions so that a user finds a customer record and then starts selecting Products in the ProductIDFK field. This is the "beginner level" method and I recommend that you set this up as phase 1. When this works for you, we know that your relationships and layout design work.

              Then, if you want better ways to find a particular product, you can use one of the methods illustrated in "Adventures in FileMaking - Enhanced Value Selection" to produce a faster, more user friendly interface design.