Sorting subset child records thru portal in master

[Jimmie99]

Hello all!

I've set up two databases, the parent and the child. I wanted to see a subset of related records from the child whilst in the parent. I therefore created a portal in the parent.

In the child I created a single calculated key with a number of paragraphs. The calculated key was essentially a field. In the field I incorporated the calculation below:

" All

[CobaltSky]

What you are trying to achieve should be possible with the use of the XOR operator.

You have not said what the calculation formula for your key field in the parent file is, so I am not able to extrapolate from your existing formula. However I would hazard a guess that the formula you will need will run along the lines of the following (at least as regards the test syntax):

Case(PatternCount(g_show, "Vertical Sector") XOR PatternCount(g_show, "All"), Vertical Sector & "

[Jimmie99]

Ray,

The calculation in the parent is:

" " & g_show

Thanks a lot for your help. I will have a go at applying this syntax. Does having the above change anything radically?

James

[CobaltSky]

No, the same principle still applies, however if the leading space is required in your current formula for some reason, then you may wish to add it into the syntax of the XOR formula also.