Hi, I could do with a little help please!
I'm struggling with something that, in my own mind, I think should be easy!
I have a field that is populated with a value list with just two values
'Not Yet Ordered'
I also have a "date ordered" field
I wish to have the date field show the date the above field is changed to 'Ordered' I did this through auto enter on modification.
My problem is that I want to delete the date and leave the field empty if the field is changed to 'Not Yet Ordered' this is the bit I'm struggling with!
Any help would be gratefully appreciated