Hi,
I'm currently creating a database for product orders (for us to use to place an order to buy something from a supplier). As part of this, there is a data entry form for the shift supervisor to complete to create an order. However, we have a situation where one shift leader may not realise that the previous shift leader has already created an order for the same part number, which hasn't yet been received. I want to be able to give a warning message to highlight there is already an outstanding order for the part and therefore not let them save the record to create the order (or possibly to give them the option to proceed after the warning).
I have an 'Outstanding Order' query sorted by part number, but am not sure how to link this to the data entry form.
Anyone have a suggestion on how to do this?
I'm currently creating a database for product orders (for us to use to place an order to buy something from a supplier). As part of this, there is a data entry form for the shift supervisor to complete to create an order. However, we have a situation where one shift leader may not realise that the previous shift leader has already created an order for the same part number, which hasn't yet been received. I want to be able to give a warning message to highlight there is already an outstanding order for the part and therefore not let them save the record to create the order (or possibly to give them the option to proceed after the warning).
I have an 'Outstanding Order' query sorted by part number, but am not sure how to link this to the data entry form.
Anyone have a suggestion on how to do this?