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, 200718 yr by Guest

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

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, 200718 yr by Guest

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

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, 200718 yr by Guest

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

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

Edited May 8, 200718 yr by Guest

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