I'm not sure this is a scripting question, but at this point I suspect that I will need to do this with some sort of script. What I am attempting is to use 2 databases to keep a running tally of sorts to provide updated information and predictions based on past information that is updated everytime a new record is cradted.

Specifically, I would like to be able to crate a new record in a second database when I click a button in the first databse. This I am pretty sure will require one script. I then have relational data from this first database record entered in the new record of the second database, add additional data to the new record in the 2nd database, and with the new data generate updated information based on the new record combined with specific data from older records in the 2nd database, and then place the new updated information in fields in the first database. (this may require a second script) I would also like to place a data scructure of some sort with the record number of the second database into a field in the first database that would allow me to know where the information for that record came from in the second database. There may also be multiple second database records used to provide data for the information placed on the first database record. I hope this isn't to confusing.

Has anyone attempted this sorta thing?

Yes.

-bd