<< The materials have a customary way of being ordered. It seems to me that I need to have an additional PrintIndex column in my materials table and some sort of form to arrange the materials in printing order. >>
Yes, you want a column in Materials to specify the material order (I always call this column SortOrder and make it INTEGER). You can either allow users (those users who should have the capability to change this information, that is) to type the numbers in directly or to use buttons with R:Base code behind them to move a material "up" and "down" a list. This assumes that the sort order for Materials is the same across all orders or jobs the materials are used in. If that's not the case, you need the SortOrder column on the table that links materials to jobs. -- Larry
