AnsweredAssumed Answered

Populate database from lowest hierarchy

Question asked by Roman_S on Jul 5, 2017
Latest reply on Jul 5, 2017 by Roman_S

Hi Everyone!


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?


Thanks, Roman