Jump to content

Welcome the ORIGINAL FileMaker Community

Take a moment to join us, no noise, all FileMaker...We Promise


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

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


Important Information

Terms of Use