Just Wondering, Email addresses offer the benefit of being unique values for sure. However, they are not very helpful when you have a large amount of users to choose from. Especially if you use the "built-in" filter method. If you append the first and last name to the email address as described here, http://www.productivityenhancement.com/support/DisplayKBArticle.cfm?id=49A17 CE5-F08F-4278-490A-E85EEACBF753&Page=1 it is a lot more recognizable, but not really since the built in filter of the <cf_DisplayFilteredSelect> filters on the first letters of the email address not the first few letters of LastName.
Plum doesn't work with compound keys and lastname is just too easy for repeats. My application, as I assume many others is a business application, where registered users are employees, subcontractors or established customers. As such, almost all fields are required, except address 2 and a few others. So, what if when you created a new user one of the fields (in the database not the form...submitted as a variable called UserName). It would basically be a combination of values entered on the add form for the plumUsers table, as such: "#Form.LastName# + '_' + #Form.FirstName + '_' + #Form.Phone#". Something like: <cf_PassColumnToAction column="UserName" type="integer" value="#Form.LastName# + '_' + #Form.FirstName + '_' + #Form.Phone#" valueIfEmpty="NULL"> Forgive me if that is the wrong syntax. I actually stole that from an email sent to me by Jeff, for another issue, and I don't know if it would actually work that way. This would, for all intents and purposes, produce unique value for that field and be more searchable [is that a word?] and user friendly. It would really be cool if you could put spaces in instead of '_' but I'm guessing that would be a no no. Has anyone tried this and did it work? Mark Fuqua ********************************************************************** You can subscribe to and unsubscribe from lists, and you can change your subscriptions between normal and digest modes here: http://www.productivityenhancement.com/support/DiscussionListsForm.cfm **********************************************************************
