Hi all master

How to duplicate Master&detail table to other Master&detail table when we update APP field on MASTER DETAIL with case like this :
//MASTER TABLE
date = 2010-10-24

name = some name

cash = 1.01

app = 1 (DEFAULT "0")
//DETAIL TABLE
ACC||AMOUNT||TYPE||NOTES ||

401||300 ||A ||NOTES 1

403||2500 ||B ||NOTES 2

405||140 ||C ||NOTES 3
how to duplicate to another table when app = 1

with duplicate table struktur like this :
CREATE DUPLICATE TABLE DEPENTON DATA ON DETAIL TABLE

DUPLICATE 1

//MASTER TABLE B

date = 2010-10-24

notes = NOTES 1

app = 1

type = A
//DETAIL TABLE B
ACC || AMUOUNT ||

1.01 || 300 ||

401 || 300 ||

DUPLICATE 2

//MASTER TABLE B

date = 2010-10-24

notes = NOTES 2

app = 1

type = B
//DETAIL TABLE B
ACC || AMUOUNT ||

1.01 || 2500 ||

403 || 2500 ||

DUPLICATE 3

//MASTER TABLE B

date = 2010-10-24

notes = NOTES 3

app = 1

type = C
//DETAIL TABLE B
ACC || AMUOUNT ||

1.01 || 140 ||

405 || 140 ||
-------------

Thx b4 for support guys