Lets say there is a Company table and a Employee table.

Company Table fields:

CompanyID

Company Name

Company Address

gStatus

etc

Employee Table fields:

EmployeeID

CompanyID

Employee First Name

Employee Last Name

Status

etc

If I wanted to have a portal show the records of the contacts for each company, with a radio button for full-time status and part-time status, its no problem as, I can have the relationship match on CompanyID and gStatus to Status.

Now the problem is that I want the user to be able to select an option to show ALL the employees regardless of the status.

I tried making a match from the gStatus key to a calculation field in the Employee table, but that would not work. How come calculation fields can not be used as a match key?

Any suggestions how to achieve the end result?

Make your radio button into a checkbox and allow both types of status.

I can not use checkboxes. I need the user to basically click a button behind a radio button field that would envoke a script to change the key value.

Ok, perhaps there is more going on here than I can see. I am enclosing a very minimal example of what I mean. Look at the company layout.

status.zip

ahhh thanks. It was the missing carriage return. That works.