I'm seeking a relational database type software. I am studying nutrition support for disease so I need to document concepts such as disease, symptoms, diagnostics, substances, drug interactions, etc. with all cross referenced to appropriate relationships. For instance, I may have data on a disease (Scurvy) which is vitamin C deficiency; so Scurvy would have a link/relationship to vitamin C. Vitamin C may have a link to Drug Interactions. Thus if I was performing a lookup on that drug, I might find that the drug causes a decrease in the levels of vitamin C which might manifest as Scurvy. Also from vitamin C I would find links/relationship to food sources of vitamin C or specific vitamin companies that carried vitamin C. I may have started this entire look-up because I was looking into the symptoms of a patient that presented with bleeding gums which linked to Scurvy and Vitamin C; along with other possibilities for the symptom of bleeding gums; and maybe then a link to dental procedures, ad infinitum.
I want to spend time studying, not building a database. Most of my searches for software end up at CRM programs. I could probably use MS Access but have never found Access to work intuitively for me. I'm willing to put in a reasonable amount of time learning the software but I am trying to avoid working through the initial learning curve only to realize it is not the product I need.