Help needed for an Arnhem Database

Discussion in 'The Lounge Bar' started by Paul Pariso, May 6, 2010.

  1. Philip Reinders

    Philip Reinders Very Senior Member

    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
     
  2. walmer_10

    walmer_10 Junior Member

    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
     
  3. Paul Pariso

    Paul Pariso Very Senior Member

    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!! :D

    All the best..........
     
  4. Paul Pariso

    Paul Pariso Very Senior Member

    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!! :lol:

    All the best....
     
  5. Paul Pariso

    Paul Pariso Very Senior Member

    Well I just finished book number 14 and the names are up to 4510.
    Slowly but surely.........:D
     
  6. wtid45

    wtid45 Very Senior Member

    14 books out of how many :lol:
     
  7. Paul Pariso

    Paul Pariso Very Senior Member

    14 books out of how many :lol:

    360+ :huh:..........
     
  8. TomTAS

    TomTAS Very Senior Member

    Hi Paul,

    When you get to 40,000 ish do let me know :)

    Cheers
    Tom
     
  9. Paul Pariso

    Paul Pariso Very Senior Member

    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?? :lol:
     
  10. TomTAS

    TomTAS Very Senior Member

    Hi Mate,

    Andy let me have his from all is work at Kew and wait for it 10 years.... So crack on:lol:;):unsure:
     
  11. AndyBaldEagle

    AndyBaldEagle Very Senior Member

    And still needing some work!!!!!

    Andy
     
  12. slaphead

    slaphead very occasional visitor

    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.
     
  13. ronald

    ronald Senior Member

    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
     
  14. Paul Pariso

    Paul Pariso Very Senior Member

    Hi Mate,

    Andy let me have his from all is work at Kew and wait for it 10 years.... So crack on:lol:;):unsure:

    My point exactly!! :p:lol:............
     
  15. Paul Pariso

    Paul Pariso Very Senior Member

    Ronald & Slaphead

    My head hurts now!:huh: :lol:.......
     
  16. Paul Pariso

    Paul Pariso Very Senior Member

    Just broke the 6,000 names mark today! :)
     
  17. Philip Reinders

    Philip Reinders Very Senior Member

    6000 to go hahaha
     
  18. horsapassenger

    horsapassenger Senior Member

    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!! :mad:.

    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!! :lol:

    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
     
  19. ronald

    ronald Senior Member

    Just broke the 6,000 names mark today! :)

    Congrats Mate, how many books have you done..?

    Ron
     
  20. Paul Pariso

    Paul Pariso Very Senior Member

    6000 to go hahaha


    :p
     

Share This Page