1 2 Previous Next 22 Replies Latest reply on Aug 7, 2009 2:28 PM by philmodjunk

    Browsing Related Records

    QueryJoel

      Title

      Browsing Related Records

      Post

      Hi,

       

      Problem:

      I can't seem to go to the right related record from one layout to another.  The relationship is defined correctly but navigating between related records seems to be a road block.

       

      Background:

      Job database is the main primary database.  ("Summary" layout)

      Cost items is a portal of which is a list of external work done for a particular job.  The details on this list of work and the costing of such suppliers are filled in another ("Details" layout)

      The relationship between the two tables is based on pkQUOTE_ID (Summary) = pfQUOTE_ID (Details)

       

      Example:

      Job has 2 records:   Mapletree condominium construction & St. Andrew roadworks

      Mapletree condominium has 3 cost related items:  Piling works, steel works & sand supplies

      St. Andrew roadworks has 2 cost related items:  Labour supplies & Equipment hire

       

      If the user is at the Mapletree condo job and he clicks on button with the script "Go to Layout - Details", he may end up on the details page pertaining to St. Andrew roadworks instead.

       

       

      Thank you very much. 

        1 2 Previous Next