2 Replies Latest reply on May 16, 2008 9:16 AM by paross1

    2 tables 1 datasource

    blackandwhite Level 1
      Hi,

      I have a single datasource with two tables. In table 1 I have lots of data with a single column (Notes) containing a value (1-4) which relates to a note. In table 2 I have the corresponding note number and description:

      TBL1
      Column = Notes
      1

      TBL2
      Column = Note
      1
      Column = Description
      Blah blah bla

      I would like to be able to display the correct note description relative to the note number displayed. i.e. the user makes a selection, say 10 results ensue, against two of these notes 1 and 2 appear.

      At the bottom of the results page I would like to display notes 1 and 2 with the relevant description.

      Hope this makes sense, TIA.

      Trevor