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