Search results

I think your table structure should look like this (attached)

Looking at your layout, you have far too many tables. You need to rethink your assemblies and components as you appear to have an individual table for each component and assembly details

Could this idea catch on? http://www.abc.net.au/news/stories/2009/11/18/2746481.htm

At the risk of sounding churlish You have got to be kidding! I would suggest 2 billion in sales (ie American bullshit eg General Motors, we are biggest so therefor we must be best) but 20 cents in data security / IT planning. Long before now, did it not occur to you people that you needed...

No demand for oil - maybe the middle east would get on with settling their religious differences while the rest of the world got on with developing alternative energy - Maybe not a bad thing

Ditto for most of the worlds auto makers - Gee, what would happen if they all went bust?

Depends on what Sample field is set as - Numeric or Text. If good design should be numeric and storing the ID number of Items. If not, and you are storing Text, then you need to link Items to ItemsOffer and set to ""

an Update query that updates the Sample field to null, based on the match with the other table

I KNOW I got very lucky with the weather, there for a total of 7 days and 7 days of perfect weather!!! I'm sure that will degenerate with this government selling out everything to private interests. - Don't make our mistakes, years ago our government spent a huge amount of money, time & effort...

mmmmmm Gumbo - Good! Really enjoyed the music

Hey, I'm not complaining, just I guess the human condition of wanting something you haven't got

Gladly (but the temptation was too great) Don't pass it on, but I had a really good time in New Orleans & Chicago

And as a bye the bye, you Yanks caused this mess, don't whinge to us that you are paying the greatest penalty

No idea, but here in sunny (drought riddled) Australia, it is under 6

Spending a while contemplating the nature of the universe, where would you rather be? Having spent 2 visits to to Sweden at the peak of their summer, this is my choice. Consistently one of the highest living standards in the world, and yet one of the highest suicide rates - what's the catch...

As always I would be grateful for any help. The way I've got it at the moment I've got Person ID as a Unique (no duplicate) primary key, but as a text field not auto number. That is then linked to the same field (not primary key) in the other table, with a one to many relationship. I would...

Thanks for the update

Create a new database and import all tables, queries, forms etc and then see if it works correctly

Are all your Windows updates up to date?

Make sure you have the database in a trusted location - Vista does wonderful things when it isn't