Douglas, Try modifying your database design to check for the options, even obscure ones like (say) all-wheel drive.
You then merely have to "loop" through the field of, say, options/accessories and substitute a form field (or better a picture) if the model supports that option. I can send you demo code if required. Have a good one! == Peter Tilbrook Macromedia ColdFusion Applications Developer 4/73 Tharwa Road Queanbeyan, NSW, 2620 AUSTRALIA Phone: (02) 6284 2727 Mobile: 0401 973 415 Email: [EMAIL PROTECTED] ICQ#: http://wwp.icq.com/666275 WWW: http://www.coldfusion.dns2go.com/ -----Original Message----- From: Douglas Brown [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 2 July 2002 4:09 AM To: SQL Subject: Help w/ relations 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 layout I have so far is as follows. I imagine I need to add another table such as [optionsList] but which will be the pri key table blah blah blah [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] ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
