Automatically Import data from a related table based on the name of a given string.

Dear ninox community,

i would like to create a table "Overview", in which I have several "historical events" listed.

Now each of these events shall be assigned a subtable or a simple view field, which searchs for/and then imports data from a related table "Records", based on the name of the historical event.

For example:

Historical event: Ancient Greece

Now i would like to make ninox look out for the string "Ancient Greece" in another table "Overview" and import all results into a view field or subtable in the ancient greece data record.

Thanks for your interest, I appreciate every answer.

Best, Paul