Selected Parameters and corresponding values in table

[griffter]

Hi all.
I have a parameter where users select multiple values from field a. In the same table there is a field b and I want to display the values that correspond ie:-

field a has values Form 1, Form 2, Form 3 Form 4
field b has values "this is a form that describes etc", "this is a form that is used in xyz", this is a form that is different again, this is a form that is used for something else
The user selects form 1 and form 4 I want to return the corresponding description.

field a field b
Form 1 this is a form that describes etc
Form 4 this is a form that is used for something else

Any ideas how I achieve this????

 

[Madawc]

I'm not sure what you're after. If you want different records from the same table in a single detail line, the best way is to add the table again, as an alias.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[Turkbear]

Hi,
If each record has both field a and field b then just place them both on a detail line and use the passed parameter values in your record selection formula.





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[synapsevampire]

Perhaps you're not filtering the data accordingly, as the previous responses indicate, you simply palce the fields on the report.

To filter only this data on the report,. use Report->Edit Selection Formula->Record and place:

{table.field} = {?MyParameter}

-k