Search results

This is rapidly developing into something more complex (as most Access applications do) than was first described. A scaled down ERP system is an extemely complex difficult assignement without knowing the answers before you ask the question - BUT, if you get it right, the world is your oyster...

Looking at your data, a Production Order can have more than 1 item, each with its own Production Rate, so I think you need a 1 to many join (see attached)

Can you attach your database? It would make it easier to see solution(s)

The over-riding theme for this is 'Favourite', not who you think is the best - although they may well be the same

For 'spectacular' shots, Seve Ballesteros for me is still the master - Woods obviously makes fewer mistakes, but to get out of trouble from a bad drive, give me Seve any day

Don't know enough about it comment, I have only seen snippets of him on TV, although I know he is widely regarded as the most gifted of all of them

With all the doom and gloom in the world currently, I thought it was time to get back to simpler things. Sports performers who have taken my breath away on how easy they amke it look: and in no particular order. Running - Sebastian Coe. The final kick, with no obvious effort glides past the...

Oh peachy, so every enquiry will immediately degenerate into a US UK slagging match !!! In seriousness - if Bob left us anything, it should be examine the facts (data), act within the rules (of Access) and THINK !!!!!!

We're doomed !!!! How we will survive without him???

Because the people that destroyed the World Trade Centre were based there!! Do you want you bring them to justice or not????? Then again, if the world actually delivered all those billions they were going to donate to the Afghanistan reconstruction in the first place, the law abiding...

I am thinking along the lines of - attached

I think you need to redo your tables, you have duplicate data, which is not good. if you have a Paper_tbl you can list all your papers, gsm etc and use this in the Stock_tbl where you can record PO's, print job usage and current stock

Don't spend too much time on how to collect data from these various sources - what is important is what is what data do you need to improve the Ugandan Coffee Growers This will detemine your db structure

Right at this juncture, after several wines too many, I will refrain from setting you on a wrong path. - however, I will review after a good sleep

At first view, you need to rethink tblPWC - it looks to me that tribes needs to be in a seperate table

Hopefully, recoverying from the hyper-inflation caused by certain countries that should have known better, that solved their current problems by printing money, rather than earning it !! Yanks, Poms - for all the 'across the pond' banter, you BOTH got this wrong !!

One hopes, for the millions unemployed, that 2010 will be MUCH better

Tut, tut, tut - should not this be a database????

tblPreviousName PreviousNameID CurrentName PreviousName YearFrom YearTo I would suggest a TeamHistory table linked to tblTeam to store previous names etc that way you won't have duplicate data like CurrentName.

Brilliant!! - It's so obvious once someone points it out Very many thanks