use the stored procedures (in the DBC) to store the function that will generate the new ID you can then set the field's default value property (when modifying structuer) to point to that function Arnon > >Help, I am trying to add new records to a grid. When selecting my new >button I would like to have one of the columns default to certain unquie >numbers. Anyone have any ideas on how to do this? > >Thanx > >Holly Clawson > >