I need to create a portal showing the records that do not match criteria.

I have a table showing appointments and one showing people. I was able to join an instance of the appointments table to itself to show any overlapping appointments. There is a portal that shows any people currently attending an appointment. I need one to do the opposite. I need it to show all available people. Any ideas would be great

If you create a field, List (self-appt. relationship::people's ids), it can be used as the originating key of another relationship to the People table. The operator would be "≠" (not equals). This is generally called "dwindling". It sometimes requires a Refresh Window [x] "Flush cached join results" step to make the changes visible.

[Oops, this requires FileMaker 8.5 or higher. You should upgrade if you can, as this is a very useful function. If you cannot upgrade, then you have to create a Value List of the people's IDs, based on the self-appt. relationship, then specify it in an unstored calculation using ValueListItems (Get(FileName), "Name of value list"). Yeah, PITA, compared to 8.5+.)

Edited November 27, 200817 yr by Guest

There's a demo file here:

http://fmforums.com/forum/showpost.php?post/246150/

It's for version 8.5, but the older method is also included.

this is not exactly what i mean i included an example. btw i am on 9 just didn't update my profile.

i just need a portal to show the opposite of the busy portal

thanks

example.fp7.zip

ohhhh looking at it more i think i understand now thanks

i am on 9 just didn't update my profile.

Make sure you read the rest of the thread I linked to, then - rules have changed again with v.9.

WOW thanks so much this works great exactly what I needed. basically just a calculation field of stuff you don't want brilliant!!