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

Marcel

Edited December 18, 200619 yr by Guest

If both tables have a patientID field then:

Try changing the table2 field[patientID] to [table1::patientID].

Corey....

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?

Changing the table2 field[patientID] to [table1::patientID] worked and seems to do what I need. Thank you.

Marcel