We have a custom tab created for item revision where the users enter item revision and the related data. The requirement is to get the active revision number from there and update the header field called ‘Current Revision’ on the item, this is another custom field. I have tried defaulting on the field setup but it does not give me an option to go through this custom record for the item and pick the value of revision where inactive is ‘No’. In the screenshot below, the highlighted field ‘Current Revision should show a value of ‘2’ as that is the only active revision.

answered in #C298P0BCK https://netsuiteprofessionals.slack.com/archives/C298P0BCK/p1625746203343800