Relationship Woes__ not just at home anymore :)

[LabMole]

Hello All. 

Just dipping my toes into FM and finding it opens many possibilities. Still must learn a lot to be proficient, so TIA for help.

Background: I sign out molecular diagnostic cases.

• We have a compendium of tests run in the laboratory (all the tests that can be ordered, run and reported out)
• A Test (type) can be run on many patients.
  • A test (instance) has one patient and each test/report/result has a patient (one).
• Each patient can have >1 tests.
• There are a set number of reporting options per test  (TestA results can be Positive, Negative, Suspicious, etc (options are in a value list)
  • Each report (ex: TestA/ReportPositiveHomozygous) has a specific text content (Table TestResults)
    • (Pos/Neg, Report text, disclaimers, method, references)

I seem to have figured out many of these relationships (I've attached my db)

Where I'm stuck:

1) I have not been able to create the relationship between the test result (tr_TestResult)  and the patient instance to link the result text to the patientTest instance (currently TOC Patient|TestResult).

2) (not relationship related... rather a calculation problem): How to do the calculation so that TestOrdered:TestFinalized gets timestamped when TestOrdered:TestStatus is set to "Finalized".

 

Thanks for the help!

 

Molecular Reporting.fmp12