ApplyFilter II?

J

Jonathan Parminter

-----Original Message-----
Can anyone provide any input on this? ANY help is
welcome, thanks again!

Gary
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
 
G

gary

-----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
.

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

Gary
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top