Subject How to fill detail table with record secuence into master table
Author

Hi to all,


I have two tables with a master detail relation.


The detail table has the fields "id", "master_id" and "detail_id".


I need to fill the "detail_id" field with a sequence from 1 to n for each record in the master table.


I can't figure out how to do this.


Any help will be appreciated.


Regards.


Hernando.