XXLERATE Posted September 9, 2007 Share Posted September 9, 2007 I have a Person database with a linked table of codes. Each person can have an unlimited number of codes assigned to them. So, on the main view for people, there is a portal to the PersonCodes table (joins People and SubjectCodes). When I enter find mode, I can only enter one code to search for. This works fine for OR searches as I can just make a new request. But, I cannot figure out how to do an AND search. Is it possible? Thanks for your help. Link to comment Share on other sites More sharing options...
Søren Dyhr Posted September 9, 2007 Share Posted September 9, 2007 It is poke into this whopping folder: http://www.moyergroup.com/documents/unnatural_acts_with_portals.zip ...after a template called something like PortalAnd.. --sd Link to comment Share on other sites More sharing options...
XXLERATE Posted September 10, 2007 Author Share Posted September 10, 2007 Hmm, i see the file. But there is no explanation and I am not able to make sense of the example. Do you mind explaining it? Thanks! Link to comment Share on other sites More sharing options...
comment Posted September 10, 2007 Share Posted September 10, 2007 I don't think that file is relevant to your question. In a nutshell, what you need to do is find the people with the first code, then re-enter Find mode, make a request with the second code and - instead of Perform Find - do a Constrain Found Set. Link to comment Share on other sites More sharing options...
Søren Dyhr Posted September 10, 2007 Share Posted September 10, 2007 Do you mind explaining it Sure - The template have a hardwired request, that seaches a textual summary of what's occuring in the portal. The real challenge is how to make this calc'field cope with all permutations, that reaches further than what a series of requests made to the first line of the portal - as Michael suggests. The template uses the sortorder you get from ValueListItems( which I havn't thought much of as to how efficient it really is. However if we then rule out the Moyer template as method, is there still a problem in designing the metaphors if a relative unskilled person is going to make these searches - and be certain to get the right result. Stacks of requests isn't likely to convey a sence of a intuitive user interface. I have a solution, I'd rather not reveal : - because it approaches or even thresspasses the edge of a personal design principle, and hope others will be able to come up with something more obvious??? --sd Link to comment Share on other sites More sharing options...
XXLERATE Posted September 10, 2007 Author Share Posted September 10, 2007 OK that makes sense to me. Thank you. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6207 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