Jump to content

Auto-enter calculation not working

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

Recommended Posts

OK, I am completely mystified...

Tables 1 and 2 in my database are related by a field called sampleId (ie, table1::sampleID = Table2::sampleID). Each table also has the text field "patientID", which does not participate in the relationship. In Table1, both sampleID and patientID are entered manually.

Problem: In Table2, I would like to have patientID automatically update to be the value of patientID in the related record from Table1. Seems simple. In table2, I defined patientID to be an auto-enter calculation from this field in table1. However, the entry in table 2 stubbornly remains blank despite a non-empty field in table 1.

I tested the relationship between tables 1 & 2 by showing the contents of a field from table 1 in the layout of table 2, and this appears to be working fine. I think I defined the field correctly. I also tried tapping the side of the computer to see if that helps....

Any thoughts welcome


Edited by Guest
Link to comment
Share on other sites

An auto-enter calc that references a related table does not automatically update unless it's 'triggered'. There are a few events that will trigger, record creation and match field change come to mind.

I'm not sure what you're trying to accomplish, but if you give more information, we may be able to help.

Perhaps you could define the relationship to include PatientID = PatientID?

Link to comment
Share on other sites

  • 1 month later...

This topic is 5696 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.