Jump to content
Sign in to follow this  
yt_ao

find or filter

Recommended Posts

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 by Guest

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 by Guest

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 by Guest

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Edited by Guest

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×

Important Information

By using this site, you agree to our Terms of Use.