yt_ao Posted May 3, 2007 Share 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 Link to comment Share on other sites More sharing options...
Søren Dyhr Posted May 3, 2007 Share 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! --sd TextMod.zip Link to comment Share on other sites More sharing options...
yt_ao Posted May 6, 2007 Author Share 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 Link to comment Share on other sites More sharing options...
Søren Dyhr Posted May 6, 2007 Share 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?? --sd Text_sj_OR.zip Link to comment Share on other sites More sharing options...
yt_ao Posted May 7, 2007 Author Share 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 Link to comment Share on other sites More sharing options...
Søren Dyhr Posted May 7, 2007 Share 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 Link to comment Share on other sites More sharing options...
yt_ao Posted May 8, 2007 Author Share 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 Link to comment Share on other sites More sharing options...
comment Posted May 8, 2007 Share 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 Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6196 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now