Nested select Statement

[Willie78]

Hi all

Basically col1 is a user input field col2 is a number that links multiple record together

i.e
col1 col2
ca 1
cc 2
ca 2

I am looking to create a selection criteria that selects dependant on another. So if col1 = cc then select all in col2 with the same group number.

In the instance above it would select row 2 and 3

Can anybody help me on this

Cheers

Paul

 

[lbass]

Add your table a second time so that you have Table and Table_1. Link the tables on the Col2 field. In your record selection formula use:

{?parm} = {table.col1}

In the details section, place the {table_1.col2} field and any other {table_1} fields you want displayed.

-LB

 

[synapsevampire]

I think that you may want to make the join a Left Outer.

Further clarification might be in order if this doesn't work, such as how you intend to display for col1 = "CA". SInce it has all 3 rows per the example, what might the output look like?

-k