Jump to content

Relatioanl Scripting!?

This topic is 7335 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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?

Link to comment
Share on other sites

This topic is 7335 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

  • Create New...

Important Information

By using this site, you agree to our Terms of Use.