Hi
I have a table for Status Values...
ID Status Value Preceeding_Status_ID
26 CV Received 0
27 Invited for Interview 26, 29
28 Rejected at Shortlisting 26
29 Interviewed 27
30 Rejected after Interview 29
31 Contract Offered 29, 32
32 Contract Accepted with Conditions 31
33 Contract Accepted 31
34 Contract Started 33
The preceeding status ID field is used in a query and the criteria is the ID field. So, as soon as CV Received is selected from a Combo Box, the Combo Box requeries itself and shows any list items that have 26 in the preceeding status ID field. Its a sort of Workflow Combo Box.
However, I want to enter more than one value in the preceeding status ID field. So, in this example, how would I find 26 in the preceeding status ID field ? What syntax would I use in my query criteria ?
Ive managed to do it by adding a SECOND field for Preceeding Status ID but I'd like to know how I would do it this way.
I hope this is clear. Thank you in advance.
I have a table for Status Values...
ID Status Value Preceeding_Status_ID
26 CV Received 0
27 Invited for Interview 26, 29
28 Rejected at Shortlisting 26
29 Interviewed 27
30 Rejected after Interview 29
31 Contract Offered 29, 32
32 Contract Accepted with Conditions 31
33 Contract Accepted 31
34 Contract Started 33
The preceeding status ID field is used in a query and the criteria is the ID field. So, as soon as CV Received is selected from a Combo Box, the Combo Box requeries itself and shows any list items that have 26 in the preceeding status ID field. Its a sort of Workflow Combo Box.
However, I want to enter more than one value in the preceeding status ID field. So, in this example, how would I find 26 in the preceeding status ID field ? What syntax would I use in my query criteria ?
Ive managed to do it by adding a SECOND field for Preceeding Status ID but I'd like to know how I would do it this way.
I hope this is clear. Thank you in advance.
Last edited: