Probably best to use an example of what I am looking for. Lets say I have a simple, one table, database of my music collection. One of the fields contains, of course, the artist's names. I want to ensure I enter the artist's names the same way each time, so I want to be able to just choose the name of any artist that already exists in the database, rather than type it in again, and so avoid minor differences and spelling problems.
In other database systems I have used a things like a dropdown list that is populated by a query on the artist name column, filtered uniquely so each name appears only once on the list. (An added bonus would be if the list is filtered when I start typing - i.e. if I type a few letters, say "bea" the choices are narrowed to those containing "bea" and so I can find and choose "beatles" for example)
Does handbase have any way to do something like this (or achieve what I want by an other means)?