Hi. Hoping someone has an answer to my below problem. I’m sure there is a way.
I have a database I use for tracking IT problems (tickets). The form I use has a field to select who the ticket was opened by. To select this, I created a query that shows only active contacts (users) and set the “opened by” field to use this query to select the user. It works great except for the fact that once a contact is no longer an active user their name on the opened by field is blank and no longer shows on any old tickets they had. Their name is still associated with the ticket though. I know this because I have the “opened by” field set so when it loses focus it opens the contact record (form) of the user so that we can update their data. So I find it weird that the opened by field on my old historical tickets won’t show the name of a user who is no longer with us but the field itself knows who it was and brings up the contact form for the non active user after lost focus.
I hope this makes sense. I'm not so sure it does after reading it again
I have a database I use for tracking IT problems (tickets). The form I use has a field to select who the ticket was opened by. To select this, I created a query that shows only active contacts (users) and set the “opened by” field to use this query to select the user. It works great except for the fact that once a contact is no longer an active user their name on the opened by field is blank and no longer shows on any old tickets they had. Their name is still associated with the ticket though. I know this because I have the “opened by” field set so when it loses focus it opens the contact record (form) of the user so that we can update their data. So I find it weird that the opened by field on my old historical tickets won’t show the name of a user who is no longer with us but the field itself knows who it was and brings up the contact form for the non active user after lost focus.
I hope this makes sense. I'm not so sure it does after reading it again
