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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...

Important Information

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