Recent content by quiksilver1984

I've been lumped with a bit of a nightmare database. Full of bugs, mistakes and inconsistencies. Not helped by its sheer size. I'm not a particularly advanced user, but im doing my best to straighten it out. A lot of people in the office have been adding to it over the years, and quite often not...

Thanks Pauldohert, ill give that a try later today and let you know how i get on. Some of the records in the satellite tables are given field names which arent present in the main table of oil fields. Will this query assign them a blank ID value where a matching name isnt found in the main table?

Thanks very much for your reply Mark, unfortunately i dont think that quite gets at what im asking. Perhaps i havent explained my problem very well- I want to add the auto number primary key of main table, as a column in the smaller tables, to use to link to. The smaller tables currenly are...

I have a main table which contains data on Oilfields. This is set up with an auto number for ID and a name of each oil field. I have other tables which contain things such as Pipelines, Wells and Platforms, which are linked back the the main table. The problem is that the database was given to...