Hi,
I'm currently running 2 seperate sharepoint databases, one which stores a form and table which stores "scores". Another database which compares scores from the table within this to the data entered in the variance database. I currently have the scores table within the variance database and a dlookup is pulling these scores into the form.
Would the best approach for this be to pull the data into the variance database from the scores database using VBA? If so how?
Or would i be able to run a dlookup to look into the variance database and pull in the scores i need?
Or neither? If there's a better way that would be even better.
The dlookup is pulling the scores based on the CaseID selected in the form.
Thanks in advance
James
I'm currently running 2 seperate sharepoint databases, one which stores a form and table which stores "scores". Another database which compares scores from the table within this to the data entered in the variance database. I currently have the scores table within the variance database and a dlookup is pulling these scores into the form.
Would the best approach for this be to pull the data into the variance database from the scores database using VBA? If so how?
Or would i be able to run a dlookup to look into the variance database and pull in the scores i need?
Or neither? If there's a better way that would be even better.
The dlookup is pulling the scores based on the CaseID selected in the form.
Thanks in advance
James
