yt_ao 0 Posted May 3, 2007 (edited) 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 Quote Share this post Link to post Share on other sites
Søren Dyhr 2 Posted May 3, 2007 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! --sdTextMod.zip Quote Share this post Link to post Share on other sites
yt_ao 0 Posted May 6, 2007 (edited) 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 Quote Share this post Link to post Share on other sites
Søren Dyhr 2 Posted May 6, 2007 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?? --sdText_sj_OR.zip Quote Share this post Link to post Share on other sites
yt_ao 0 Posted May 7, 2007 (edited) 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 Quote Share this post Link to post Share on other sites
Søren Dyhr 2 Posted May 7, 2007 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 Quote Share this post Link to post Share on other sites
yt_ao 0 Posted May 8, 2007 (edited) 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 Quote Share this post Link to post Share on other sites
comment 1,489 Posted May 8, 2007 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 Quote Share this post Link to post Share on other sites