Hi all,

I am trying to run a access query and I want to populate Line Number(Automatically). For a set of keys I want to write Line number for eg: below:-

Order No Prod No
-------- -------
1 11
1 11

I havea field in the database called the Line number, but Line Number should start from One and then to two and so on depending op the key. As soon as the Prod No changes or Order no changes the Line Number should reset. The concept is identical to a Details(Header/Detail) file. The Detail file will have Line numbers. So the final key would be (Order No+Prod No +Line Number) Please help