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] ______________________________________________________________________ Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.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
