Oh yeah your "options" list would be sourced from a separate table and referenced as a list (eg: 1,7,9,11,49) which might be referenced as:
1 - Power steering 7 - Anti-lock brakes 9 - Driver/passenger airbags 11 - Batmobile rocket accelerator 49 - Anti-police invisiblity. Alll you would need to do then is to loop through the list and identify to the user the options available. == 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] ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
