Hi everyone,
first post for me! Thanks to all REI3 staff for this incredible tool.
I'm working on a TCM (traditional Chinese medicine) app.
One topics I'm working on is creating a "syndromes" archive, which contain syndromes and relative symptoms.
I've three relations (tables): syndrome, symptom, rel_syndrom_symptoms.
rel_syndrom_symptoms is the relation containing data for the many to many relation between syndroms and symptoms.
My problem is that when I add a symptom to a syndrome I need way fo avoid duplicates.
For example, if I add symptom "Headache" to syndrome "Liver Qi Uprise" now I can add it again and again, causing mistakes.
How can I avoid this, so "Headache" (or any other symptom already selected) can't be add again?
Thanks for support!