i thought this would be easy

[VICH]

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.

[Fitch]

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

[VICH]

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

[Fitch]

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.

[VICH]

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

[LaRetta]

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.