AnsweredAssumed Answered

Displaying Companies by Category on Portal

Question asked by keith on Apr 15, 2012
Latest reply on Apr 16, 2012 by keith


Displaying Companies by Category on Portal


FMPro11 and Mac 10.6

A Companies file with each Company having a Category which is a single item made up of 3 ‘parts’:

Primary (approx. 10 types), e.g. Contractor, Secondary (approx. 30 types), e.g. Plumber, and Sub (approx. 20 types), if applicable, e.g. Heating. Result: Contractor Plumber Heating. 

Primary and Secondary parts are limited to one word each. The Sub part is for specialist aspects or where there is insufficient similar Companies to form a separate Category, etc. There is a single Category field with a Value List. The Value List is long but acceptable as it is only used for setting up a new Company which happens infrequently.

There is a Portal to display Companies based on Category (Primary and Secondary parts only). A shorter Value List (approx. 30 items) shows, for example: Contractor Electrician, Contractor Plumber, Supply Tools, Supply Materials, etc. The Portal is filtered with ‘LeftWords 2’ to trim off any Sub part and make the match.

The problem is that I would like to display some Companies in more than one Category on the Portal, e.g. a Contractor who is both a Plumber and Electrician. I have given a Company several Categories but only one will display. I tested Categories with no Sub element and LeftWords removed but no better. Is there any way to achieve this. I am happy to try a completely different approach.