ADDING A LINE NUMBER SO THAT I CAN PRINT REPORT BY LINE NUMBER

[kaniz]

I have database that was created a while ago. Because of some new reports that need to be produced I need to add a line number to the database. I basically have two questions. I tried to add a field lineno to a table with index duplicates ok but I could not save the table it kept changing to duplicates not ok. How do I solve this problem, also how do I reset the line number every time and order is added on a form
for example

work order 508596 line 1
line 2

work order 508965 line 1
line 2
line 3

Any suggestions please.

 

[raskew]

The technique is explained in this article:

http://support.microsoft.com/support/kb/articles/Q98/7/90.asp?PR=ACC

 

[kaniz]

Thank you for your reply. I think I did not explain myselft too well. I apologize.I need to be able to store the line number in the database everytime the user enters and order on a 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 incremnt the line number for every unique record and then reset it when the order number changes
thank you