Hi,

Does anyone know of a way of generating a select field from entries added to the database?

For instance, if there was a field called Select, and it was a series of comma delimited entries, how could I use that as a select field? I've tried referencing a select field entry's contents to $rec{Select} but that generates an error message.

On the same topic, how could I append data to a specific field? The field (in this case the "Select" field) is at the end of the database entry for each user. Does anyone know of a way in which I could add a variable (parsed from a form) to the end of the "Select" field for a specific user?

Any help would be greatly appreciated.

Sure, use:

print &build_select_field_from_db ('Column', $rec{'Column'});

and it will produce a select list of unique values in the database.

Hope that helps,

Alex