Is it possible to update one record on a table from another record in a form?
I have a form that tracks orders. It shows if one order is replacing another. If it is, the database checks to see if the old order needs cancelled. If it does, a message appears on the screen letting the user know that the old order needs cancelled. Is there a way for the database to enter a date in the cancellation field of the old order while on the record for the new order? That way, I would be able to run a report detailing the orders that need cancelled.
Any assistance you can provide would be greatly appreciated.
I have a form that tracks orders. It shows if one order is replacing another. If it is, the database checks to see if the old order needs cancelled. If it does, a message appears on the screen letting the user know that the old order needs cancelled. Is there a way for the database to enter a date in the cancellation field of the old order while on the record for the new order? That way, I would be able to run a report detailing the orders that need cancelled.
Any assistance you can provide would be greatly appreciated.