If I understand you correctly, different users are responsible for entering different information specific to each Part Number. Using conventional Field Validation would present ALL Users with a warning message when field values are missing, so you want to present specific Users with specific warnings, correct?
If so, have you defined different Privilege Sets for different User Accounts to limit access to specific fields (or have you created some other way to distinguish one User Group from another)?
A script can determine on the basis of Get(PrivilegeSetName) which fields in the Part Number table are still empty and require data from the current Users Privilege Set. As in:
If [Get(PrivilegeSetName)=”[HTUsers]”] /*Heat Treatment File Users*/
Show Custom Dialog (“Please enter the Weight of Part# “ & Part#ID)
Go To Field (PartNumber::Wieght)
You can trigger this script from the Layout using the <On Record Commit> trigger.
Go to Part Number Data Entry layout In Layout Mode
Select Layout Setup… from the Layout menu
Select the Script Triggers tab
Select the On Record Commit trigger and specify the script