find or filter

[yt_ao]

Hi:

I have a problem:there are two table,it is T1 and T2.Now I want find(or filter) the data through

"F1" or "F2" field in "T2" table.How to do?thank.

Text.zip

Edited May 3, 2007 by Guest

[Søren Dyhr]

I would DeMorgan the matter but at present can't you do it without adding a serialID to the secondary table ...well at least I think so, if you can come up with a better way will I gladly listen!

--sd

TextMod.zip

[yt_ao]

hi Søren Dyhr

see the file,Now I want find(or filter) the data through field"F1" or "F2" in "T2" .How to do?,please point.thank you.

Text.zip

Edited May 6, 2007 by Guest

[Søren Dyhr]

I'm not getting it, do you mean as a selfjoin, perhaps if you could give an example where such a feature is an ideal interface??

Is it one of the attached templates, that does what you're after??

--sd

Text_sj_OR.zip

[yt_ao]

I want to use undermentioned way to search for record

1、I use Find to search for some record by "F2",without any data displaied in the "F1" this time,see 1-1.

2、I use Find to search for some record by "F1",twithout any data displaied in the "F2" this time,see 1-2.

3、I use Find to search for some record by "F2" and "F1",see 1-3.

how to design the database? please point,thanks.

text.zip

Edited May 7, 2007 by Guest

[Søren Dyhr]

Would you please take your time to read this carefully?

http://www.joelonsoftware.com/articles/fog0000000036.html

...and in this particular:

http://www.mojofat.com/tutorial/step1.html

We havn't got the faintest clue, if it's portalized filtering or is basic seaching you're after!!! Why?? The threads name is a bit of both! A technical nerd ...like me, would think this is about boolean OR's....

--sd

[yt_ao]

i am sure,that is "it's portalized filtering".how to do?please give me a example.thanks for your help.

Edited May 8, 2007 by Guest

[comment]

I think Søren is trying to say your request is not clear. It's very difficult to follow abstract examples like T1, T2, F1 F2.

In any case, I think your original file could look like this.

Text.fp7.zip