2 new records in 2 databases simultaneously

[Hotarunohikari]

I have two databases both are related and contain info on one subject but must remain separate. Is there any way that anyone knows to create a new record in both simualtaneously and relate the two? preferably i would like to do this using the create new record option in the menu because this will be a shared database and i do not want to confuse people. if this is not possible is there any way to disallow the use of that command for this database only?

any help is appriciated

thanks

aaron

[danjacoby]

I suggest writing a "Create New Record" script. Then use passwords to limit menu access to your users.

[falkaholic]

Make a script that calls other scripts in each of the 2 databases.

like so.

FirstDB

Performscript(external, db1, newrecordscript)

performscript(External,db2, newrecrodscript)

and then is eeach of the db's have a scri[pt called newrecordscript that just does:

new record/request

one you run the first script it will bring the dbs to the front each with new records.