1 Reply Latest reply on Jan 26, 2015 5:26 AM by philmodjunk

    Relationship

    thong127

      Title

      Relationship

      Post

      Hi All,

      I am trying to show all the products that we ordered from our suppliers using a portal for printing & also in list view. below is the info of what Im working,

      I have two tables (Products and Suppliers)

      In my Product Table I have the following fields

      PRODUCT MATCH ID FIELD   ; Text              ; Indexed. Auto Enter serial,

      Receiving No.                             ; Number        ; Indexed, Auto enter serial

      Product Name                            ; Text               ; Indexed

      Manufacturer                               ; Text               ; Indexed

      Supplier                                       ; Text               ; Indexed

      Quantity Ordered                          ; Number        ; Indexed

      In my Supplier Table the fields are the following

      SUPPLIER MATCH ID FIELD    ; Text              ; Indexed. Auto Enter serial

      Supplier Name                            Text               ; Indexed

       

      The two tables is connected by the ( PRODUCT MATCH ID FIELD = SUPPLIER MATCH ID FIELD )

      In my Suppliers table I have a portal setup that shows a record from my Product Table ( Show Related record from (Product) ; Sort Portal records ( Receiving No.) ; Filter portal records (Product::Supplier) but its not working

      Any help rendered is highly appreciated.

      Thank you so much!

       

       

       

       

       

        • 1. Re: Relationship
          philmodjunk

          And where/how does this fail for you?

          What exactly do you mean by "all the products that we ordered from our suppliers"?

          That would seem to be a case of simply going to a layout based on products and selecting show all records so I think you want something a bit different than that.

          Most systems for handling PO's use more tables than what you have here. Usually there is a table of purchase orders, a line items table and a products table listing all products that you might order from your suppliers. A suppliers table would be a fourth table in such a set up.