I have had this answered on another forum. Apparently using max() + 1 is not a good idea as it can cause duplicates.

I know I said I didn't want to...

Unfortunately I cannot. The records that the trigger creates are not to be created before the details entered into the tblCable record is created.

I think there must be a way...

Hi,

Thanks for replying.

I don't know if I should have mentioned the trigger but as it is affected by the field I am trying to populate I thought I should.

The trigger...