I need some simple code to achieve auto line numbering as per the LineItem 

number discussed in chapter 2 of the Access 2000 Programming book.



The illustration (p.33) shows the OrderDetails table being normalised to 

include a Line Item number.



I have a similar database and would like to know how to get the Line Item 

number to increment with a new added record.  Autonumber doesn't work 

because the Line Item number is relevant to the OrderNumber.



Thanks in advance



Tony