I have an app to register samples in a lab. Numerous tests using different technologies can be run on the same sample. For eg., PCR tests PCR1, PCR2 and FISH test FISH1 can be run on sample S1. To achieve this, I have created a table to store sample data (Sample_Data) and another referenced table to store tests data (Test_Data).
I also have difference apps for individual technical departments to use to update their observations and results which are all connected to the previously mentioned Test_Data table.
My query is - how do i display rows belonging to a specific technology in it’s respective app in a way that only some fields from the Test_Data are editable.
PFB the link to the tables: