Hello,
I'm trying to prevent an update to a record if a three digit code in the center of a compressor model number does not match the first digit of a unit model number.
For example:
Unit model number F054VHN = Compressor model number ZP103KCE-TF5-455
I've attached my database. Thank you very much in advance.