Search results

No, the ID will be the make number. The first table only needs ID and Make. The second table needs ID, MakeID and Model. The join (like you have above) needs to go from ID in the first table to MakeID in the second.

Bummer, hate it when they don't do anything and just drive off. It's because people are afraid of the cost implications of owning up. There are so many fake injury claims these days meaning insurance companies have to make big increases on their premiums. So by owning up and having it come off...

No it won't go down but it won't go up. It's pretty simple maths really. The more they pay out the more they need to charge people. If you're not injured and you make a claim for injury it's fraud. Or would you prefer a simpler version?

Sorry for the delay, just got home from work. Not used Access in anger in donkey's years. Not sure what you need to click/access to be able to paste the query in but from that view you should be able to do it: In the top pane under 'Table 1' click on ID and keep you mouse down and drag it...

Off topic, but do you actually give yours beans when you do take it out. Do you even get above like 3-4k revs?

Re: My new R27 F1 Team He's selling it. It's in the For Sale section (or was).

Woah, woah. The make and model aren't consistent across rows? You either need to make 'Make' repeat across each row e.g:Make | Model | Other Ford | Focus | other fields here Ford | Fiesta | other fields here Renault | Clio | "" Renault | Megane | "" Or have two tables e.g:'Make' table: ID |...

It does.

Uh yes.

SELECT Model FROM [table-name-here] WHERE Make = 'Ford'. Your DB needs normalizing, but you'll learn that craft later on.

Me too, Man, me too!

You're just too kind, James!

Not injured enough to be off work = not injured enough to be making claims for injury. Pretty simple I thought.

So basically you're going to commit fraud. Have you ever moaned about how much insurance is? Now you know why; people like you who feign injury to get money they don't derserve. Thanks for pushing my insurance up year-on-year. Wanker.

Are you actually injured, Lee?

Welcome and all that.

Welcome and all that.

Sounds like the guy might have not taken the exit he was supposed to. There's a roundabout I use everyday (J2 of the M621 going onto Elland Road for people in Leeds). It's a DC with the M621 overhead, so 1st exit is East bound, 2nd exit is the continuation of the DC and 3rd exit is westbound...

Re: My new R27 F1 Team Nice, but I prefered the Trophy tbh.

Why not just attach it to the outside or is it not very strong?

Same in any 172 lol. Just like braking hard or sudden power decreases on the bends.

Welcome and all that. Car looks nice! Looks a bit lower on the back than the front though? I'd prefer to see the back raised a bit personally. But that's just me lol.

Welcome and all that.

Welcome and all that. Take no notice of the narrow-minded xenophobes on here!

He's Clio crazy, He's Clio mad, I can't think of a Clio that Jay hasn't had.

Cool beans! Did well there, fella. But Interior, ICE, Security & Insurance ?

Good stuff. http://www.cliosport.net/forum/faq.php should tell you everything you need to know.

Welcome and all that. Has it got the cup packs on it? What colour is it?

Welcome and all that.