2 Replies Latest reply on Jan 18, 2010 8:40 AM by tommytowbar

    Portal help

    tommytowbar

      Title

      Portal help

      Post

      Hi

         I have a portal in my products database where i can list stock .i list wiring kits for that towbar is it possible to take this information eg price from the portal and add that to the towbar price or is there a easyer way to do this

       

      Andy Notton

       

      filemaker pro 10.3

      vista

       

       

        • 1. Re: Portal help
          Steve Wright
            

          Hi Andy

           

          There's not really enough information here to be able to give proper advice on (for me anyway) but ill try...

           

          If your using a portal, there obviously exists a relationship.

           

          So, lets say your table was named lineitems  (where you entered the towbar )

          If you had a field in here for a part number, this could be related to the products database

           

          LineItems -> ProductsDatabase 

          PartNo  =  PartNo

           

          By entering (or choosing from a value list) the part number of the wiring kit into the line items table

          you could then have it lookup the remainder of details, such as description, price etc.

           

          So for instance, the price field could be a lookup field.  When defining the field you could choose the options for

           

          'Lookup'

          Starting with table 'LineItems'

          Lookup from related table 'ProductsDatabase' 

          Then select price from the related fields. 

           

          I'm not sure if this is what your looking for though, so excuse me if I have read it wrong.

          • 2. Re: Portal help
            tommytowbar
              

            hi

               got it working ok now not sure what was wrong but ok now

             

            thanks for all your help

             

            Andy