Jump to content

i thought this would be easy


VICH
 Share

This topic is 5611 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

This topic is 5611 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.