Subject | How to fill detail table with record secuence into master table |
---|---|
Author | |
Post date | 2016-01-22T23:37:12Z |
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.