Jump to content
TanyaI

Linking two databases

Recommended Posts

TanyaI

Hi I need to link two databases via a calculated value or find a work around. One database has auto-entered ID (ENT00xx)  for demography and then an auto-entered id for blood sampled. The number which is important is a calculated value. ENT00XX.1, ENT00xx.2 that is generated using ENT number and then the visit number 1,2,3. The visit number is a field. I have linked the 2 databases via this calculated number however the link is apparently invalid and doesn't work. I can see all the fields from ENT database but when put on layout the calculated value has "?" in it. Other fields from ENT database brings up error that link is invalid. Is it a calculated field problem or have a mucked things up somewhere? I have another database which I have  linked in similar way except it is not a calculated field it is an auto-entered field. It is working. Any help would be appreciated

Thanks T

Share this post


Link to post
Share on other sites

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

×