duplicating

[j_u_s_t_i_n]

how can i duplicate the records that is inside a portal?

for example, i have 4 tables. the first one is transactions, with fields: recID(autoenter serial), name, date, amount. 2nd one is transItems, with fields: recID(autoenter serial), transID, item, qty. 3rd is duplicates, with fields same as transactions. and 4th is dupItems, with fields: recID(autoenter serial), dupID, item, qty.

transactions::recID is linked to transItems::transID

transactions::recID is linked to duplicates::recID

duplicates::recID is linked to dupItems::dupID

now in the main layout, im showing the fields for transactions (recID, name, date, amount) with a portal showing the related records from transItems. also in another layout that works exactly the same as in main(let's call this main2), except that it is for the duplicates table.

now there is a button named "duplicate" in the main layout. it must duplicate the current record including the portal items in the main2 layout.

if my explanation is not clear, ive attached an exercise file that ive been testing on.

thanks alot!

Exercise1.zip

[Søren Dyhr]

Poke into this archive and find a template called DUPPORT.FP7

--sd

[j_u_s_t_i_n]

hi! ive finished my work at last! thanks alot!