Jump to content
Sign in to follow this  
modles

AND searching with related portal records

Recommended Posts

Hey guys

I know its pretty difficult to explain stuff like this in a forum post and i'm not sure my topic title is the best use of words, however i will give it a shot...

I have a table of job candidates with a portal record set of skills for each.

i.e Joe Bloggs has a related records in the table 'skills' with the following entries 'sales' and 'audit'.

Now searching is where im getting confused. When i switch to search mode i can obviously search within the portal, and i can create new requests in order to have or searches based on multiple skill options. I.e I can find someone who has 'sales' skills OR 'audit' skills.

However, I can't work out how to have AND searched for skills. I.e i need to find someone who has 'sales' skills AND 'audit' skills. So basically i need to search for someone who has multiple related records matching my search.

does that make sence? I hope so ! smile.gif

I have attached an image of the database in browse mode. This shows Joe Bloggs record with his two skill entries in the portal record at the bottom. So as you can i see i need to come up with a solution to search for candidates with skill 'a' and skill 'b' along with the ability to search for candidates with skill 'a' or skill 'b'

HELP! smile.gif

Many thanks in advance

regards

ben

uk

Share this post


Link to post
Share on other sites

Skill is more of an attribute than an entity. If you make skill a checkbox field you will be able to AND the skills.

Share this post


Link to post
Share on other sites

I understand where you are coming from, however as you will see on the screen grab there are other attributes that are attached to the skill, therefore i can only think they must be related records.

ive found this thread...

http://www.fmforums.com/threads/showflat.php?Cat=0&Number=107328&an=0&page=8#107328

so this could possibly be a solution but i think it going to be a nightmare with the number of fields in the portal records.

I really want to be able to make the user able to build a search by entering a value in one of the portal fields then selecting 'and' / 'or' from a drop down and entering a value in another (or same) field. i.e building a search row by row.

cheers

ben

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.