Hi All,
I'm working on a maintenance ordering system and one of the conditions is that nobody can place an order for that particular day after 10am that morning. If it's after 10am they can place an order for the following day no problem. Is there a way i can prevent a record being added to the database if it's after 10am and also have a message appear on the screen saying something like "No orders accepted after 10am. You may place an order for tomorrow instead". However, if the order is ok and placed before 10am, as per the rules, i'd like the message to say "Order accepted".
Hope i've explained that ok
Any help would be great,
Cheers Em
I'm working on a maintenance ordering system and one of the conditions is that nobody can place an order for that particular day after 10am that morning. If it's after 10am they can place an order for the following day no problem. Is there a way i can prevent a record being added to the database if it's after 10am and also have a message appear on the screen saying something like "No orders accepted after 10am. You may place an order for tomorrow instead". However, if the order is ok and placed before 10am, as per the rules, i'd like the message to say "Order accepted".
Hope i've explained that ok
Any help would be great,
Cheers Em