1 Reply Latest reply on Jul 18, 2011 1:55 PM by philmodjunk

    Something simple? can someone help me please?



      Something simple? can someone help me please?


      im trying to help a computer illiterate friend with a simple thing for him to use for pricing but cant work out how to do it.

      I have 1 table


      In that table i have

      Prod_Id - indexed

      Product Category

      Product name

      Product size

      Product Colour

      Buy Price

      Sale Price

      I have 2 layouts

      "Price List"

      "Product input"

      What i want to do is add some products into the db on the product input page then one the Price list a couple of drop down lists based on the product category, size and colour and when they are selected in a box below shows the item name, item colour, item size and sale price.

      I just cant get my head around portals and been trying for hours to get one going but cant.

      any help appreciated.



        • 1. Re: Something simple? can someone help me please?

          Define the following fields in your existing table or a new table (Script assumes same table here):

          gProductCategory, gSize, gColour

          With each of these, specify global storage:

          Write this script:

          Enter Find Mode[] //clear the pause check box
          Set Field [Products::Product Category ; Products::gProductCategory]
          Set Field [Products::Size ; Products::gSize]
          Set Field [Products::Colour ; Products::gColour]
          Set Error Capture [on]
          Perform Find []

          Put gProductCategory, gSize, gColour on a layout and add a button next to them to run the above script. If you want, you can add a go to Layout step to switch to a layout set up wtih view as list or view as table to display the matching records found by this script.

          (You could do this with a portal, but then we'd need a relationship to a second table occurrence of your products table before you could set that up.)