Hi Doug, You look to be on the right track ... From the table descriptions I'm guessing your queries look like inventory.id = options.inventory_id ... What you'll really need likely is a 3rd table (unless you already have one) which only holds the name and/or description of the option ... so ...
inventory.id = inventoryoptions.inventory_id inventoryoptions.option_id = options.id Or something like that... ( I usually try to name my id columns like options.option_id rather than options.id though it's not necessary ) When you display the form with the checkboxes for options, you'll collect the option name from the options table, then left join the inventoryoptions table to determine if the car being updated is related to the given option... When you display the details for the vehicle, you'll collect the car info from the inventory table and left join both the inventoryoptions and options tables -- or draw a separate query with inventoryoptions and options inner-joined where the inventoryoptions.inventory_id is equal to the inventory_id passed to the page in the url or form... Hope this helps, Isaac Dealey www.turnkey.to 954-776-0046 ______________________________________________________________________ Get the mailserver that powers this list at http://www.coolfusion.com 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
