I see your point! I will try that as you suggest. On Apr 11, 2005 1:18 PM, S. Isaac Dealey <[EMAIL PROTECTED]> wrote: > These are predefined departments arent they? > > Even if they aren't, why would you subject yourself to the horror of > adding a database column each time a user adds a category? That > exactly the sort of problem relational databases were designed to > solve -- so you wouldn't need to add columns. (That's the "relational" > part -- as opposed to a non-relational database which is merely a > spreadsheet afaik.) > > The information in my last post applied to a list of pre-defined > "categories" (which sound to me like hospital departments), however, > it still will work with a variable number of departments, you would > merely need an additional form page to allow users to update the > tCategory table, which is hideously simple -- it's a standard > create-read-update-delete (CRUD) form. Then once you or they have > populated the tCategory table the code in my previous post can handle > associating those categories with your other form record. (It might be > helpful if we knew what the categories are being associated with -- > presumably the form is used to update information about something > other than the form itself.) > > > I think that the steps are: > > > 1) I have to develop a CF page where the user can enter > > the information for new checkboxes. > > > 2) once the user enters the information, the column in the > > database has to be added > > please don't... do a google search for "third normal form". Trust me, > you'll be grateful. > > > 3) Also, the checkboxes have to be auto-populated on the > > CF Page where the user is going to actually make data > > entry for forms, categories, and all other things. > > The code I supplied will do that for associating categories with the > form record. > > > The step 1 and 2 are relatively easy since I simply need > > to alter the table, but I am not sure on how to approach > > the Step 3. > > see the code in the original message... but it's steps 1 and 2 you're > planning to do in a way that you'll regret later. > > > s. isaac dealey 954.522.6080 > new epoch : isn't it time for a change? > > add features without fixtures with > the onTap open source framework > > http://macromedia.breezecentral.com/p49777853/ > http://www.sys-con.com/author/?id=4806 > http://www.fusiontap.com > >
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202215 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54