I am making a teaching feedback form where I want to select a comment from a list box in a form and then have an associated value with that comment (the mark) to both display on the form and go into another field in the table associated with the form. I have created a table for the list box that has both a comment field (Quality_Comment) and its corresponding mark field next to it (Quality_Mark) next to it. The list box works fine, but how to use teh other value is my (probably pretty simple) problem.
I last did a database in FileMaker Pro in 1999, so I am running on that knowledge, so I would appreciate the help. I suspect I am using the incorrect terms. I would upload a screengrab but I doint have the requisite point (what are those?)
Thanks!