Database Microsoft Access help =(?

Question

Ok basicly I have made 6 seperate tables and some include the same thing for example,

Type of Car, I dont want to have to type into each one the type of car so how can I make it so I type the information in one and it gets placed into all of them.

Same for names =)

Ive done that and they are connected but it dont seem to work... hmmm

Answer 1

You should have ID's as a primary key.. for example if you have a table with car_id, car_type, car_name, car_color as columns, you can have the car_id as a foreign key in all the other tables that you need...

you should read more on databases basics dude...