I have Window 8.1. I am a doctor. I made a list of 700 diseases. And I have coded them 1 to 700. Next I made a list of 700 symptoms. I have coded them 1 to 700. Next, for every disease, I gave all their symptoms code. Next, for every symptom, I gave all their disease code. Now I want to know by which application can I relate the diseases with symptoms and relate symptoms with diseases. So that in the end, if I click few symptoms then the relevant disease with these symptoms will pop out. Can you help me?

---

Reply from Alex Hedley:

MS Access will do this.
You can import this data into two tables.
Diseases and Symptoms
Then create a Junction Table DiseasesXSymptoms that has the DiseaseID and the SymptomID.
Create a Query that Joins these and you can then show them in a Form or Report.