Increment a col integer against a related row value

[JamesWB]

Hi, I have a table Hazard that I want to create an increment row value in, using the formula (MAX(Hazard[Hazard Number]) + 1).

Hazard rows are Keyed to the table Machine. I want to have these integer increases tied to the specific machine in Hazard.

I'm a bit puzzled about which function to use. I basically want to select rows tied to a particular machine and increment the value in the Hazard Number field each time a new hazard is added, but each machine ID has its own list of hazards.

Will much appreciate any help.

thanks

James