Hi Guys,

I hope this has been done before. I cannot seem to find a posting for this though, so if anyone can help I would really appreciate the assistance.

I need to create a dynamic drop down menu based on fields within the existing db.

In other words the drop down has $rec{'field1'} as a value and $rec'{field2'} as the select text. All except blank fields must be filled in. If at all possibe the fields should be alphabetically sorted to make the drop down easy to read.

Thanks in advance
G