Hey guys,
I have three fields, order number,status and DetailDate. If an agent enters an order today, he will be duplicating the record until the issue gets resolved,but the agent will need a intimation on the 5 th day..i need the status field to turn red on the 5 th day not only in the form,but also when the agent searches the DB with the search cmd button.
Any ideas grtly appreciated!