2. PHPRunner General questions
  3. [SOLVED]  making a record invissible
This topic is locked
[SOLVED]

 making a record invissible

 		6/26/2014 10:45:09 AM
PHPRunner General questions
S
 shoppy author

Is it possible to make a record invisible.
I have a database with employees and clients.

Some of the employees no longer work for us but I cannot delete them because there are documents attached to them.

Now I like to give them a status like 'ex' or something to make them invisible in 'Custom View' but let them visible in 'Table' to edit it.
Is this possible?
John
N
 		nti 6/26/2014

if table has field called "active" field type = int, size = 1, default = 0 and utilize it for employees as active = 0 and inactive = 1.... custom view requires active.
S
 		shoppy author 6/27/2014



if table has field called "active" field type = int, size = 1, default = 0 and utilize it for employees as active = 0 and inactive = 1.... custom view requires active.


Thanks Mike, I made it like you said but how does this make the record invisible?

You say: "Utilize it for employees as active = 0" but how do I do that?
John
N
 		nti 6/27/2014

with "Query Designer", your "active" Column, Filter, =0 produces all active employees or =1 produces all inactive employees.
S
 		shoppy author 6/27/2014



with "Query Designer", your "active" Column, Filter, =0 produces all active employees or =1 produces all inactive employees.


GREAT Mike,
It worked, thanks you ever so much.
John
J
 		jasongreenwood 7/19/2014

Hi there,
I've got a similar situation and have setup =0 active, =1 inactive but how can I change the labels to show active or inactive and the value of 0 or 1 behind those?
Thanks



GREAT Mike,
It worked, thanks you ever so much.
John