i have 2 database which is tb_aduan and tb_admin. i have a form in dreamweaver where user will use it to add new record to tb_user. the 2 database were connected with relationship on id_aduan(autonumber). however when user key in the new record, only record in tb_aduan will be added but not tb_admin.


what i have to do to make the record in the tb_admin increase according to the increasing of record in tb_aduan?

Sounds like you need to add an INSERT trigger to the tb_aduan table, or add additional code to your form to do a second INSERT to the tb_admin table.

actually i've tried to do that, but it still cannot run. may be my coding is not right. can you give me the instruction or example.

thanks