thanks for the response ray & bkelley! 

just to be sure on this point:

"the name of the driver stays in only one table, you don't want to spam that out...

the real question is...

how does your company feel about supporting work visas?

the real question is...

how does your company feel about supporting work visas?

bkelley... many many thanks for your help!

how would you create the junction table in this case?

what columns exactly?

i'm guessing some thing like this:

lastname, firstname, car1, car2, car3, car4, car5

if i'm...

the selects would be easy if it were a single driver, and a single car.

the problem for me is there are multiple cars per

driver.  how does one insert those values...

technically this would be a join statement though right?

thanks for the response.

unfortunately it's not a browser based setting.

this is the only forums where this is happening.

i could use notepad, but that can get pretty

annoying ya know.

i can use...

the junctions no problem.  relations.. no problem.  inserts tough.

just trying to get a better grasp of it. 

thoughts/examples?

yeah i know... i was just using the 'chris' & 'smith' as an example.

just learning the basics here, and thought i would throw that out ther.

question is... is there a...

you guys rock!

these example are just what i needed. thanks guys!

another question thought...

so if i create the 3 tables Cars, Colors, CarColors, then open

the diagram 'add the 3...

many thanks.

i'm going over the example they have there.

i just need more practice at making these things.

even more practice with joins. i have a tough time

seeing the logic in...

don't think i like joins. trying

to know them better at the moment.

they are critical. it's the only

type of operation that makes many-to-many

worth-while.

so it's not possible to set up a many-to-many relation ship with the diagram

tool? i've been trying it, and it's prompting me to create rows so that the

table can...

oh man... thanks! the picture is starting to clear up now.

question though... i'm not that good at tsql, and would

like to know why this is all about --> identity(1,1)

i...

i got it now.

Each entry in the drop-down list is preceded by an icon. A key icon indicates that the table participates in the relationship as the...