Question: |
| I'm attempting to get historical Excel data uploaded into ESDAT. I've populated the Lab Reports Table, the Chemistry Samples Table, and the Chemistry Results Table. All were successfully validated and imported. Now, when I go to Lab Reports, the report is there but is says "There are no chemistry samples for the selected Lab Report", despite already validating/importing chemistry samples and results. | |
|
|
|
Answer:The reason the historical sample is not showing under the lab report is because the lab report number is not populated in the chemistry sample table import.
You will need to update that field to connect the lab sample to the lab report.