Multiple check box options - Any advice would be appreciated
Hi Guys, Please could I have some advice on what I am trying do, which is:-.
I have my database which is attached.
May I just add that I am new to sql and databases.
I have created a database which will be used for selling used cars. I have run DA and created the forms that will insert the information, Make Model mileage option etc.
I have created a separate table for option's, such as air con, leather seats, cd auto-changer etc.
Where I have run into difficulty is how to have all the options shown as individual check boxes, so when adding a used car to the database, you have all the different options shown as check boxes and can tick only those options that the car has so when you click insert, all the information for that car is inserted to the database.
I hope that this makes sense.