NICE WORK PAUL I have started a namelist many years ago, got some 12.000 names, but find it impossible to keep it updated. at the moment I prefer to work on the KIA/MIA database
Paul Hope you received the book with enclosures okay..I was delighted to find out the 'real' name of the Phantom patrol NCO and the fact his BEM recommendation mentions his time at Arnhem. I have put him in my latest Nominal ROll of GHQ Liaison Regiment...just want to find out more about him Asher
Paul Hope you received the book with enclosures okay..I was delighted to find out the 'real' name of the Phantom patrol NCO and the fact his BEM recommendation mentions his time at Arnhem. I have put him in my latest Nominal ROll of GHQ Liaison Regiment...just want to find out more about him Asher Hello mate, Yes, I received the book, thanks very much. I think with the amount of new material you're collecting a second edition must be imminent!! All the best..........
NICE WORK PAUL I have started a namelist many years ago, got some 12.000 names, but find it impossible to keep it updated. at the moment I prefer to work on the KIA/MIA database Thanks a lot Philip . I'm not sure if I'll reach the 12,000 mark anytime soon but you never know!! All the best....
Hi Paul, When you get to 40,000 ish do let me know Cheers Tom Will do mate! By the way, how long did it take you to put together a list that large??
Re Super database. Just a quick point told to me by the bloke that used to program the database at work. Keep it Simple Sonny! I know precious little about the infernal things, but I have been told that so long as your database software is "relational" you can build your super database out of existing standard databases so long as you have the same field names (that contain the same field content type - so date of birth is always in the form 12/03/1920 and not like that in one database and 12th March 1920 in another) So you could have one database per book Each database has the same fields that are needed for book type data. Then your super database actually contains nothing, it just looks at (is related to) the book databases. So in the super database you search for all men named "Jones" and then have different report forms lists a subset of the fields in the book database depending on what data you want to give to people such as "firstname" "rank" "date of birth" "bookname" "page number" that way you can easily check if you have the same guy twice, or track his promotion status, but for an external researcher you could just give "first name" "book name" "page number". The other flexibility this gives you is that if at a later date you want to add the publisher and ISBN number you dont have to add that to every record in every database. You just create a new database with just the book title, piblisher, ISBN number etc and then "relate" the book name to the other databases so that when the super database looks up a record it sees the book name and then looks at the book title database and gets the ISBN etc from there. You could then do the same for all sorts of other info, or someone else can be working on a wholy different database and so long as it relates correctly, all that extra data can then be read by the super database.
MS Acces is relational and does that. Actualy you have to setup different "Tables" lets say "Book-Table" and "Name-table". You then can relate corresponding fields in the tables with each other and produce Prints or Queries wich display only the fields you want. It has a Wizzard to do this very fast. Its indeed easier to expand your database then with other "Tables" but if you don't plan to do that you might as well use other software as Paul does. Ron
Hi Mate, Andy let me have his from all is work at Kew and wait for it 10 years.... So crack on My point exactly!! :p............
Hi all, Well I found out that the "Access" software comes as part of MS Office 2007. Great I thought, I recently bought this software so it'll be on there somewhere!! Silly me!! I bought the 'basic' edition of Office and 'Access' is part of the Professional version. OK I thought, not a problem, I'll just see if I can buy 'Access' on its own. Not a chance!! MS don't do it as a stand alone piece of kit (not that I could see anyway) and that means buying the Pro version of Office which costs a squillion pounds!! . Looks like Excel it is then (unless I win the lottery)................. PS I've reached page 26 of the FIRST of nearly 400 books and there are already 653 names.........this may take a while!! Paul I purchased MS Access as a single add on prduct for my Home and Student version of Office 2007. I see that it is now also available for Office 2010. Look around on the internet for some very good prices. I would recommend using this type of product for your project as it can be set up as a "Relational Database" which is far more efficient than anything you could do in Excel. John