We are a mining company, where we have lot of Vehicles and Equipments (ASSETS) which are under AMC.
We have individual ASSET CODEs for each Asset.
In the AMC PO, we want to mention ASSET CODE of the Asset, so that, the system to notify (waring/error message) if AMC is accidentally created more than once, for the same ASSET CODE for the same duration.
Or it may also happen that, we may prepare AMC PO for which ASSET does not actually exist (it would have been sold/scrapped).
Please suggest how to make above control.