2 Replies Latest reply on Jun 3, 2012 12:49 PM by nella

    Relationship Help

    nella

      I could use a little help with the first go at a Purchase Order.

      I’m trying to get a handle on relationships.

       

      I have four Tables:

       

      Purchase Order

      Line Items

      Products

      Suppliers

      Relationship.jpg

        • 1. Re: Relationship Help
          beverly

          I tend to add a suppliers Catalog, as a product may be sold by more than one vendor/supplier. And the cost of product is here, too, as they may have different costs to you.

           

          PURCHASE ORDER =>

          PO ITEMS (qty, price, etc.)

           

          The items are lookup from the CATALOG, bringing over the necessary fields. These are lookup rather than just related, as POs should be historical at that point in time - with adjustment items made at time of check in (cost changes, back orders, etc,)

           

          CATALOG is a join table of PRODUCT & SUPPLIER with the fields necessary for PO item lookup.

           

          HTH

           

          -- sent from my iPhone4 --

          Beverly Voth

          --

          1 of 1 people found this helpful
          • 2. Re: Relationship Help
            comment

            Have a look at the demo posted here:

            http://fmforums.com/forum/showpost.php?post/309136/