I want to exclude records from a portal based on a radio button in the original record. Without having to set up a seperate relationship, just like I would use a "constrain found set" in a report script Is there an easy way to do this?

In more detail....

I book radio presenters into editorial sessions, using a join record that takes PresenterID and SessionID joining them together with a in a new record with a time. Filtering these records with SessionID and sorting them by booking time, produces a shcedule.

This works well, now we area alowing presenters to download rather than interview our guests, I need to record this so I have put in an interview / download field (radio button). You can book with no time and select download, when I produce reports I sort by time, but exclude either interview or download. But I can't exclude in the portal that is a quick referance.

Without having to set up a seperate relationship

It seems like you're having a many2many relationship "by the book"

If you not are willing to to bolster the present relationships into multicriteria, is the only solution to have two extra fields in, in which you stash the two foreingkeys away in the join table, when selecting the radiobotton, could be done via a couple of autoenter (replace existing content) via a Evaluate( statement.

The way it should work is that the two foreignkeys get cleared, which will make them dissapear from the portal, but before that do we need to save them in the extra fields, could be oldfasion lookups! Only thing is that the size would be twice as great bytewise.

But I would definately take the plunge into the bolstering treatment instead.

--sd

Soren,

Thanks for the advise, I have gone with what you suggested and added a relationship. I try to keep the relationships down, as I am fairly new to this and I find managing multipul relationships gets a bit unwieldy.

Just out of interest are is there any way to filter a portal. I can produce reports, filtering on live or download to include or exclude, or just find on the field. Seems strange I can't automate it a portal?

Just out of interest are is there any way to filter a portal. I can produce reports, filtering on live or download to include or exclude, or just find on the field. Seems strange I can't automate it a portal?

If you're making a multicriteria relationship, are you filtering already! - investigate this:

http://www.newcenturydata.com/downloads/filter.zip

--sd

Soren,

thanks for the example, I'll have to have a good look at this. Can you suggest a good resource to get started with these more complicated calculations?

Tearing appart all the templates I could lay my hands on as well as actively debating - has proven to be my way to the knowledge I have today. I wouldn't know the best way for you to approach a topic, it could be a thoroughly reading the issued whitepapers from FM Inc. or watching these videos:

http://www.filemakermagazine.com/

...the single most important whitepaper could be reached here:

http://www.filemaker.com/downloads/pdf/techbrief_fm8_migrtn_found.pdf

One of the most comprehensive sources for templates is this:

http://www.databasepros.com/

You might perhaps benefit from following blogs, and this is perhaps the best:

http://edoshin.typepad.com/

....while his webpage, indeed contains some of the cleverest algorithms know to the Filemaker community:

http://www.onegasoft.com/tools/index.shtml

You should obviously put the uploaded templates here under some investigation as well:

http://www.fmforums.com/forum/modindex.php

--sd