For this you can create a look flat table Material Types and a field in main table say Material type which is look up to this Flat Table Material Types. This table should contain all of your Material Types. Now make use of Qualified Range to generate numbers step by step as given in below guide.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.