I'm just trying out FileMaker and would like to create a relational database with phytotherapeutic drugs.
I've designed the simplest tables (phytotherapeutic drug, plant, plant family) and linked them through a unique ID.
I would now like to populate all tables "on the fly" beginning in the lowest hierarchy in the table with phytotherapeutic drugs ("PflanzenDrogen") and either attribute an already existing entry from the plant table ("PflanzenStamm") or create a new entry if it doesn't exist yet. The same would be the case for the plant family.
I've managed to link the tables and to create value lists from which to choose, but whenever I enter a new drug, it creates a new entry in the Plant table as well and if I choose an already existing entry from the list, I get an error message, since I defined the entries as unique values...
Can anyone help please?