Hello cf-Talk, I have a table that has 3 fields, that are look-up fields for other tables, and referential integrity is enforced. For example, my table is called models, and the field for year is from another table. So, if I want to make a form to edit a record in models, I'd like the formfield to show a dropdown as in a cfselect, and the correct year will already be the "selected" choice. But, the other years will also be listed in the dropdown list. I want users to be able to edit the records, but still enforce referential entegrity with my lookup fields. Best regards, Jeff Fongemie mailto:[EMAIL PROTECTED] ------------------------ Internet Guns For Hire (603) 356-0768 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
