Subject Re: [firebird-support] Master-Details Table
Author Anderson Farias
Hi,

From: "nick_the_greek"
> How can limit the records of the Details Table ,
> for example for one record in master table to have
> max 4 record in details table.

One way I can think of is creating a 'before insert or update' trigger on
detail table like:

[code]
select count(*) from detail
where master_field=new.master_field
into :detail_count;
if (detail_count>=4) than
exception some_custom_exception;
[/code]


Regards,
Anderson