Dear Friends: I'm a newbie to databases and scripting, so I need a very basic helping hand.  I've created a database to collect data about metrical events that occur in lines of poetry. The fields I've created, together with abbreviations I use for the individual events, are these:

Lines (Single-Line)

Properties (Multi-Select)

Penthemimeral (Single-Line) (pc)

Hepthemimeral (Single-Line) (hc)

Bucolic Diaeresis (Single-Line) (bd)

Homodyne in 4 (Single-Line) (hm4)

Heterodyne in 4 (Single-Line) (ht4)

I've left the Properties field blank in the outline above. What I want in this field is a summary of the events that occur in each line. I could manually select these events for each line, but I have a feeling there is a script that would instruct the application to read data in the events fields (pc, hc, bd, hm4, ht4) and return these events in the Properties field. (I set up the other fields so I could search for different combinations of these events across a wide range of lines.)

For example, let's say the event fields for a particular line have this data in the appropriate fields: pc, bd, ht4

The script I have in mind would read these events and return them in the Properties column, which is a Multi-Select field.

I'm assuming that every field in the database should have something in it (maybe an incorrect assumption), so I enter "n" in event fields that are not true for a particular line. Alternatively I thought of setting up checkbox fields for the events, so that a single check would indicate an event was true in that line. But maybe this would complicate the script I'd like to find, though it would reduce the number of keystrokes needed to analyze what could be several thousand lines of poetry. For example, a very useful script for my purposes would read a checked box in the "Penthemimeral" field and return "pc" in the Properties field.

If my very elementary sense of how this database works, together with its potential scripts, is way off, please let me know. On the other hand, if someone could help me write a script that would do what I've described, I would really appreciate the assistance. It would be great if someone could lead me step-by-step through the process of entering the script, if such a one exists.

Thanks in advance.