Omit record in portal row?

[tmas73]

Is it possible to omit a record in a portal row? If I omit a record and I look into a portal row the record stil is displayed. Is there a way around it?

Thanks

T

[bcooney]

No, it's not possible. The records that show in the portal are the result of the relationship that defines the table occurrence on which the portal is based.

Perhaps you need to filter the portal?

[tmas73]

How would a filter look like? Any directions?

Thanks for the help

T

[bcooney]

Here's a demo comment posted (couldn't find the original thread).

Filter.fp7.zip

[Søren Dyhr]

Well another way of accomplishing such a behaviour is this...

--sd

omitPR.zip

[comment]

I think it really depends on what is the purpose here: marking the record as omitted will make it so for ALL users (and sometimes may not be possible due to record locking). If the purpose is to omit the record for the current user/session only, I would use a global filtering field to write the exceptions.

[Søren Dyhr]

I think it really depends on what is the purpose here

Obviously!

--sd

[Guru Salem]

Great..

Is any way to know know the current record is omit or in show.

Thanks

[tmas73]

Thanks for the help on this on. Here more info on what I'll try to achieve.

I have a layout with self joined table to display all the records in a portal. I can browse the records in the portal and it displays the record to the right. This works all fine (hope I set it up correct). I just want to have a "Category" popup menu that shows the specific records from the category in the browser portal. I think bcooneys solution is great for my purpose. But I do not know how to implement her solution in my setup. Can anyone take a look at the screen caps and point me in the right direction?

[comment]

Is this clearer?

FilterSelf.fp7.zip

[tmas73]

This is a lot clearer, thanks. Works!

:

[tmas73]

comment, one ore question, how can I simply "Show All"?

[comment]

Take a look at the first file posted by Barbara - and the original thread:

http://fmforums.com/forum/showtopic.php?tid/201079/post/317020/#317020

[tmas73]

Ok I looked through the topic. But what if its a self joining table. That wont work that way, or?

[comment]

Why not?

[tmas73]

I created a cCategory calculation (eo_category & "¶ Show All"), I added this to the popup value and it choose the right categories but show all shows no records.

FilterSelf.fp7.zip

Edited March 4, 2009 by Guest
Added sample file.!

[tmas73]

Still trying to find a solution on "Show all", it most likely must be a simple mistake I cant figure out.

Thanks

T

[bcooney]

Your relationship is wrong. You want to match gCategory to cCategory.

[tmas73]

bcooney, thanks.