Searching Related Records
I've develpoed a summary page in my database that allows the user to search for a patient via their NHS number, and a specific disease via their Treatment ID.
The page is pretty much working as intended, however sometimes the page is not populating corectly.
Example (shown in pics): A patient with NHS number of 098 has to disease episodes, 71 and 72. Selecting 71 will populate the fields correctly, however when I select 72 as the treatment and perform the search, nothing changes.
Any suggestions as to why this could be happening?