Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Linking two databases


Recommended Posts

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

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...

Important Information

Terms of Use