Conditional Menus and Portals

Conditional Menus and Portals

Post 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

 
 
 

Conditional Menus and Portals

Post 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!

 
 
 

Conditional Menus and Portals

Post 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

 
 
 

1. Conditional portal displays with criteria from another portal

What I'd like to accomplish is displaying information in one portal, dependant
on the chosen record in another portal. In this case, the tables are client,
where the portals reside, projects, and tasks. I would like to select a
project in the first portal, and have only the corresponding tasks show up in
the second portal.

Any suggestions?

Brian

2. Encrypt table or field?

3. Conditional/Script or Portal?

4. Forms 6.0: Master-Detail Relationships

5. Conditional Portals

6. Empty all DB's in a DIR

7. Is it possible to have conditional values in a portal

8. Conditional hiding of Buttons or Fields in a Portal

9. Conditional Portals???

10. conditionals and portals

11. conditional value list in portal

12. Conditional Pulldown Menu