Auto Number

I would like to auto generate a unique 3 digit number in field "wiring_reference" in wiring "table". The number needs to be unique for each "site" which is selected from a look up field of "wiring_site" in the wiring table which looks up "site_reference" field of table "sites"