|Subject||How to fill detail table with record secuence into master table|
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.