ok i have a table. in this table there are completed and noncompleted jobs.

noncompleted = 1

completed = 2

i made a self join relation from the "check" field that hold the values 1 or 2, to a calculated field "check_calc" that = 1.

check = check_calc

the portal is supposed to show all noncompleted jobs in a portal and not any completed ones. what happens is on records with the value of 1 the portal displays All records, and on records with the value of 2 the portal displays NO records. i want it to show all noncompleted records only not matter what record you are on.

Perhaps you need to switch which field is on the left and right sides of the relationship.

do you mean the values of making it check_calc = check because i have tried both...unless i did it wrong...it still doesn't work

That is indeed what I mean: the layout you're on should be based on the TO of the constant field (check_calc) and the portal should be based on the TO of the "check" field. Double-check the fields on the portal to make sure they are based on the correct TO.

ah ok then i did do it wrong....ok thanks that worked brilliantly. thank you very much

noncompleted = 1

completed = 2

I suggest you have ONE field. 1 = noncompleted and 2 = completed (even better use 0 and 1). End of problem. Your field in the main table should be global number which toggles to switch between showing either.