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.

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

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!

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.

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

OK that makes sense to me. Thank you.