D
djcamo
Hi, i am having an issue with a field within a table that is not
active.
I have a table of employees and if they leave they become non active
(yes/no field).
We do this so that on other forms when we select employees from a
combo box they do not appear.
The issue is that for existing records where this person was involved
the name combo field shows blank as they are now deemed non active
(seen here - http://wishlistsolutions.com.au/files/demo.png)
The combo box's SQL is only showing employees who are active hence any
non active one do not display.
I cannot think of a way around this and would appreciate any help.
Cheers
active.
I have a table of employees and if they leave they become non active
(yes/no field).
We do this so that on other forms when we select employees from a
combo box they do not appear.
The issue is that for existing records where this person was involved
the name combo field shows blank as they are now deemed non active
(seen here - http://wishlistsolutions.com.au/files/demo.png)
The combo box's SQL is only showing employees who are active hence any
non active one do not display.
I cannot think of a way around this and would appreciate any help.
Cheers