Jump to content

AND search via Portal


This topic is 6121 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

This topic is 6121 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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