Doug, Are you building this from scratch or have you inherited it? Ideally I think you should have one table for Makes (Porsche, BMW, Audi, Ferrari) and another table full of options (Leather, Rear Wiper, Turbo). Then on the cars entry they can select checkboxes for the applicable options and select the car manufacturer from a Select.
Then they can have an admin where they can add/remove options to the list (Add 'Power Steering' for example). EMail me off list if this does not make sense. Glad to help. Tony Gruen [EMAIL PROTECTED] -----Original Message----- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Monday, July 01, 2002 11:46 AM To: CF-Talk Subject: DB layout questions...please help!!! I have an outomobile application to allow dealers to put their inventory online etc...but the car options, such as power steering,brakes,seats is set static on the pages and I want to make them dynamic and allow the dealer to be able to add additional opions if needed. The second question, is if the dealer adds options to the application, how do I dynamically modify the insert queries to be able to understand the new added field. As you can well tell, I am not a SQL guru and am confused when thinking in the fourth dimension. The layout I have so far is as follows. [inventory] id this table hold make, model, year etc.. [options] id inventory_id this table hold the options associated with the inventory... Douglas Brown Email: [EMAIL PROTECTED] Douglas Brown Email: [EMAIL PROTECTED] ______________________________________________________________________ Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
