<< create generator gen_admit_ordinal;

then ----

create trigger bi_patient_admissions
active before insert
as
begin
if (new.admit_ordinal is null) then
new.admit_ordinal = gen_id(gen_admit_ordinal,1);
end>>

Won't this just increment the Admit_Ordinal lineally, regardless of
Client_ID?

Clay Shannon,
Dimension 4 Software