Sorry everyone I am posting this one againg, I don't think I explained too well the first time I posted it. I apologize.I need to be able to store the line number in the database everytime the user enters and order on a subform form. I need to store in a database because I will be using crystal to print the reports. Can somenone guide me as to how to add and increment the line number for every unique record and then reset it when the order number changes
thank you
example
main form
work order 508596
main subform
work order 508596 line 1
line 2
line 3
line 4
thank you
example
main form
work order 508596
main subform
work order 508596 line 1
line 2
line 3
line 4
