Very Computer

by **Helge Hafst** » Tue, 22 May 2001 02:44:52

I want to filter a portal for products in my order file. Ive two
popup-menus for caterogy1 and category2. Cat1 is based on a valuelist
from the product file and cat2 on a relationship to the same file,
marked to show only related records. This works well and cat2 only shows
values based on cat1.

The portal where the filtering shall go on is based on a relationship by
identical text calculation fields in both files (order and product
file):

Cat1 & "PP" & Cat2 - ("PP" = carriage return)

All the related fields are indexed (on).

The result is that the records shows up if one of the catergories match,
not both as I want them to.

Any ideas?

Rgds
--

......_/_/_/_/_/_/_/..... Web: http://www.macx.no/
...._/...._/...._/....... Phone: +47 55924915 - Cell: 97548190
.._/...._/...._/......... Address: Fjellbirkeland - 5224 NESTTUN

by **Jame** » Tue, 22 May 2001 03:17:08

Hi Helge -

I haven't tested, and I will if this isn't right, but it seems to me offhand
that the carriage return in your concatenation is causing the two values to
be indexed separately in the calc field. That would explain why the
relationship is matching either field. Try simply removing it and see if
that doesn't do the trick. Please get back to the group if I misunderstood.

Best of Luck -
James

> I want to filter a portal for products in my order file. Ive two
> popup-menus for caterogy1 and category2. Cat1 is based on a valuelist
> from the product file and cat2 on a relationship to the same file,
> marked to show only related records. This works well and cat2 only shows
> values based on cat1.

> The portal where the filtering shall go on is based on a relationship by
> identical text calculation fields in both files (order and product
> file):

> Cat1 & "PP" & Cat2 - ("PP" = carriage return)

> All the related fields are indexed (on).

> The result is that the records shows up if one of the catergories match,
> not both as I want them to.

> Any ideas?

> Rgds
> --

> ......_/_/_/_/_/_/_/..... Web: http://www.macx.no/
> ...._/...._/...._/....... Phone: +47 55924915 - Cell: 97548190
> .._/...._/...._/......... Address: Fjellbirkeland - 5224 NESTTUN

--
Don't forget to remove the obvious spam block when replying.
I advocate making an address book entry and using it! Thanks!

by **Helge Hafst** » Tue, 22 May 2001 05:00:08

That simple... , this saved me a lot of frustrations! What a wonderful
group...;-)

Rgds
--

......_/_/_/_/_/_/_/..... Web: http://www.macx.no/
...._/...._/...._/....... Phone: +47 55924915 - Cell: 97548190
.._/...._/...._/......... Address: Fjellbirkeland - 5224 NESTTUN

> Hi Helge -

> I haven't tested, and I will if this isn't right, but it seems to me offhand
> that the carriage return in your concatenation is causing the two values to
> be indexed separately in the calc field. That would explain why the
> relationship is matching either field. Try simply removing it and see if
> that doesn't do the trick. Please get back to the group if I misunderstood.

> Best of Luck -
> James

Very Computer

Conditional Menus and Portals

Conditional Menus and Portals

Conditional Menus and Portals

Conditional Menus and Portals