script to copy some fields to another file

[daviator]

This should be an easy one for the Gurus:

I have two simple databases:

DB1 is a simple call log for a tech support team.

DB2 is a simple knowledge base.

I need to have the option to create a new record in DB2 from some (not all) of the fields in DB1 by using a simple switch in DB1 such as "Add record to DB2: Yes/No"

Any help on how I can pull this off would be greatly appreciated.

Thanks,

Dave

www.daviator.com