Hiii all
i have a MainFrm based on OrdersTbl that contains :
-OrderID
-OrderDate
-EmploeeID
every emploee may have more than one order , in the mainFrm (EmploeeID Before Update event), if there are previous Order in the last seven days for this emploee, an alert massage like: "There are an Order for this emploee before (Number of days) days are you sure to add new order ? "
if yes continue
else
cancel and undo.
i have a MainFrm based on OrdersTbl that contains :
-OrderID
-OrderDate
-EmploeeID
every emploee may have more than one order , in the mainFrm (EmploeeID Before Update event), if there are previous Order in the last seven days for this emploee, an alert massage like: "There are an Order for this emploee before (Number of days) days are you sure to add new order ? "
if yes continue
else
cancel and undo.