Shouldn't you have the completed part of the compund key in your primary calc as well.

Or rather, what is not completed

Otherwise, you can never trap for that.

If your going places with filtering portals and date ranges, check out this artical:

http://www.onegasoft.com/articles/smartranges/index.shtml

Its very hard to understand but you don't need to understand to use it, just 2 copy and pastes.

Its also useful to see how to filter out portals.

I have two Databases: Task Manager (Interface) and Task Manager Data

Primary Key= CurrentUserName&Relationship&Filter

Foreign Key= CurrentUserName&Administrator&Completed&Filter &(CR)&

CurrentUserName&Manager&Completed&Filter

three different relationships exist and only one filter. Basically, this is setup to allow an administrator or manager to see their uncompleted tasks for the next 14 days (Filter). However, a completed task is still showing in the portal but only for the administrator.

Does anyone know what I am missing here??

Andy/Eric,

Thanks for your response. Interesting article on date ranges.

Andy, I am only trying to trap for those items which are not completed. In the foreign key, if an item is not completed, the completed section is empty. This should then result in a match to the primary key which omits completed items. However, it seems to work when the relationship in the Task Manager field is Manager but not Administrator.

I'm still missing something.

Chris,

Have you checked the fields in both databases.

Where you have in your second database

quote:

---

Foreign Key= CurrentUserName&Administrator&Completed&Filter &(CR)&

CurrentUserName&Manager&Completed&Filter

---

you say in your last post

quote:

---

However, it seems to work when the relationship in the Task Manager field is Manager but not Administrator

---

Does this mean you have a field called task manager, that can display manager or administrator.

If so, make your calc display either or even both.

CurrentUserName&Task Manager&Completed&Filter &(CR)&

CurrentUserName&"ALL"&Completed&Filter

.

Try this and let us know how you get on.

Regards