you need to add a new table to your database that will be used as a linking table to create a many to many relation ship between the Vehicle and Options Table.
lets name the table vehicle Options:
vehicleOptionsID - primary Key columns
vehicleOptionsVehicleID - relate to the Vehicle.VehicleID column
vehicleOptionsOptionID - relate to the options.OptionsID column
to display all of the available optipons on the insert page, create a recordset:
SELECT * FROM options
then add a checkbox to the page, set the value to use the optionID column, and add the option name binding from the bindings panel next to it to show the name.
now use the data assist manage relational table behavior to along with the insert record behavior to store the selected options in the vehicle options table.
Andrew read posted a good tutorial for the manage relational table behavior here:
showpost.php?p=84393&postcount=17
