ApplyFilter II?

  • Thread starter Thread starter Gary
  • Start date Start date
-----Original Message-----
Can anyone provide any input on this? ANY help is
welcome, thanks again!

Gary
Click to expand...
Hi Gary, I think that you cannot edit sf when you link q2
to q1 as the join is too complex.

you can possibly get around this using a select within a
select. for example (air code)

select * from q2 where ((q2.ID) In(select q1.ID from q1
where ((q1.ID)<200)));

the inner select can only return a single column/field.

If required use copy/paste to create nested query string.
That is:
1. use query design to create the inner sql.
2. Ensure that the only column/field returned is the
linking field (uncheck show for any field required for
criteria).
3. In another query design create the outer sql.
4. Ensure that the linking field is in the grid.
5. Then copy from the sql view of the inner sql and paste
in the criteria row of the linking field in the outer sql.

Hope that's clear <grin>.

Luck
Jonathan
 
-----Original Message-----

Hi Gary, I think that you cannot edit sf when you link q2
to q1 as the join is too complex.

you can possibly get around this using a select within a
select. for example (air code)

select * from q2 where ((q2.ID) In(select q1.ID from q1
where ((q1.ID)<200)));

the inner select can only return a single column/field.

If required use copy/paste to create nested query string.
That is:
1. use query design to create the inner sql.
2. Ensure that the only column/field returned is the
linking field (uncheck show for any field required for
criteria).
3. In another query design create the outer sql.
4. Ensure that the linking field is in the grid.
5. Then copy from the sql view of the inner sql and paste
in the criteria row of the linking field in the outer sql.

Hope that's clear <grin>.

Luck
Jonathan
.
Click to expand...

Thanks, Jonathan, I'll take a look at it ... 'preciate it.

Gary
 
Back
Top