Field Not Empty Based On Criteria
I need to ensure that certain fields within a table are not left empty upon completion, some users forget to update these based on the type.
I have 3 main fields that are key;
Type: test 1, test 2, test 3, test 4
I need to find the best way of ensuring that the time spent field is not empty if the date completed field is updated and the type selected is either Test 1 or Test 2.
Test 3 and Test 4 are reported in a different way
I hope I have explained the above.
Many thanks for your time