Simple Checkbox -- Yes or No Question

[Joseph31]

Hello everyone,

I thought I knew how to do this but I just can not figure that last step out.

I have made a portal that indexes its self from a checkbox simply names Yes...

That works well..

I would like to flip this around... meaning I want my portal to display everything that is not checked off. I can not get this to work

I only want one checkbox -- If it is checked = Yes; If it is not checked = No

How do you get a single check box to mean no If it is not checked...

Joseph

[-Queue-]

Create a relationship from a calculation or global field equal to "yes" and the field formatted as a checkbox, and select the 'not equal to' operator for the relationship.

[Joseph31]

Ok, I tried it... I must be getting confused with all of this...

So I made a Checkbox Field in table 1

And I made a calc = Yes in table two

And I connect them but not equal to...

so The When I click on the check box it will mean yes... correct

Joseph

[-Queue-]

If "yes" is the value selected for the checkbox via value list, then when you select the checkbox, the value of the field becomes "yes". If you are using some other value (like 1) in the value list, use that in your calculation instead. It doesn't really matter what the value is, as long as the calc matches the selected value. Then your relationship will display all records where the checkbox field is not equal to the calculated field.

[Ugo DI LUCA]

I don't get your idea JayTee.

The best in my opinion would be a calc ckey = Case(IsEmpty(TheCheckbox);"yes";"no") or do it the contrary at wish.

What am I missing ?

[-Queue-]

Well, the request seemed to be to display a portal containing unchecked records for a checkbox with one possible value. So it seems easiest to use a calc/global and a <> relationship to the checkbox field.

If there were more than one item in the value list, then I'd use your calc as the 'right-hand' key in the same relationship.

[Ugo DI LUCA]

Hi,

What I understood was either show all NO or all YES with a single action to a checkbox, holding only a "yes" value (one checkbox), on the left side of the relationship.

If the checkbox is checked, show the "YES", if not checked, show the "NO" records.

The calc I suggested was for the LEFT side of the relationship.

[Joseph31]

Ok, Please guys don't Fight....

Let me expand a little more....

I have two Tables: "Welcome" and "File_Login"

On the welcome Page there are many portal... we are just working on the last one "File review Portal"

On the second Table -- "File_Login"

I have "LastName", "FirstName" along with a inset portal the is formated for direct entry -- meaning that you type right into that portal. This is where I have my Problem.

I would like a checkbox (single) Checked = "Yes" and Unchecked = "No" -- meaning that someone (has seen and review this table).

I can make value lists that say yes and No , but I wish just to have a single box...

Finally, this will be all indexed later on the welcome page in its own portal.

I just am not sure where to make the nessary fields that = yes or = no and how the relationships should look...

Joseph

[-Queue-]

Ugo and I don't fight; we discuss.

I think Ugo and I are confused on whether you want to click a box to display all 'yes' records in a portal and click it again to display all unchecked records or you want to have a portal that displays all unchecked records only. Ugo's method addresses the former and mine addresses the latter.

[Ugo DI LUCA]

Agreed.

I don't fight with this boy

[Joseph31]

Ok,

So having said that I will have to combine the two equations to make this work.

Joseph