How to create sequential number (Organism ID) in subform (Identification tab) based on Sample ID in main form (Culture Result Details)
such as Sample ID: STC-300 ---> Organism ID: STC-300-1, STC-300-2, STC-300-3 and so on
I have 6 types of Sample ID in the table (AR-001...,ARC-001...,MS-001..., MSC-001..., ST-001..., STC-001...)
Attachment 38085
Attachment 38082
Attachment 38084
Thank you