i want to have a select field from db that can be added to "on the fly" -- that is, when adding a new record (or modifying a record), the form would pull the values for Category that are already in the db. if the category i want has not yet been entered, i want to be able to type the new category in a text box and have it update the Category field (not a new field). then if i add another new record, that category will appear in the select list.
i found one old record that sounds like what i want but it is very old and i don't think it works with latest version of dbman (not sql):
see http://www.gossamer-threads.com/..._select_from_db;#404
i found one old record that sounds like what i want but it is very old and i don't think it works with latest version of dbman (not sql):
see http://www.gossamer-threads.com/..._select_from_db;#404