I tend to just have a separate interface through their main menu that will let them add/edit/delete/update companies. I have on some projects had a button/link next to the <select> that when they clicked on would pop up with the form to add a company and once submitted it would go into the database and plug the value via JS into that <select>. I tend to lean towards making it harder than easier to add things like this though. Seems like more of the users will add things not needed when they can easily add them vs scrolling through the options and picking the current correct one. This is why on our old real estate database we have things like: HOUSTON, HOUSTON-OWNED, HOUSTON-LEASED, HOOUSTON, and so on. Makes it real fun to run a report to grab all Houston properties.
On 7/22/07, Steve Sequenzia <[EMAIL PROTECTED]> wrote: > > I have a general question about how people are handling new records to > select boxes. I mean if you have a form with a select box that displays > values from a database but when the user is filling out the form they need > to add a new record to that list. > > --Example-- > Description: <textbox> > Data: <datapicker> > Company: <cfselect> > Details: <textbox> > > On this example the user wants to add a new company that is not in the > list. They need to be able add a new company. They will need to be able to > add the name and all data (like address and phone) that goes with company. > > I don't have any issues handling the insert part of this. I am just not > sure the best way to handle the interface. > > I have tried lots different ways to do this but I have never really > figured out a good way to handle it. > > Anyone out there have any pointers for me about this. > > Thanks in advance. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 and Flex 2 Build sales & marketing dashboard RIAâs for your business. Upgrade now http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:284324 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
