I'm building an app for a medical clinic. I want to note that a patient had an X-ray done in his Medical History table. But my script on the button that transports the user from the X-ray Results page to Medical History table isn't working:
If [Tests::Xray date > 12/1/2000] Set Field [Medical record::Xray; "Yes"] End If
I'm not sure if it's failing because the date is the wrong test. Or because "Yes" is the wrong value to set the field to (it was a checkbox labeled "Yes", and then I made it a field where a user could type "Yes").
Are you running the script from a layout that can see the Tests::Xray date? Is Tests::Xray date on the layout. If not place it on the layout to see if it is working properly. I'm guessing you might have a relationship problem.