Search results

Hi, I am looking at trying to use a database to help produce stats for a darts team, does anyone have any advice or know of where I can find one to get me started ? Thanks, Nick C

Hi All, I am designing a database to record info about train running,we do a lot of swapping trains around and I have designed a table to store this info, I was wondering if its possible to be able to view the trains swapped in a report and then be able to put a check box next to records...

Hi, Thanks for reply,I have got a good book on it so will check it out, thanks for help ! Nick C

Hi, Thanks for reply, I am trying to create a start on a database for where I work, I have upto 750 members of staff who work at different stations across the country some are train guards and some are train drivers, I also have platform and station staff but am concentrating on traincew for...

Hi, I am designing some tables to store data about drivers and routes and types of traction they drive can someone check out my tables and see if all is ok so far and give any advice on what to do next ?? Cheers, Nick C

Thanks Thats Great, Just one other thing, if I was to add a further table with Routes would I do the same thing and create a separate table for with Routes in it and then a further table again with Drivers Routes and do as you have said above ? Thanks...

Thanks Again, How do I then show which driver drives which vehicles ,whether all three or just two !! Thanks, Nick C

Ok thanks for reply ,could you tell me the fields etc i need to create to achieve this and where to create relationship please ,I have Autonumber ,FirstName,LastName,PayNumber,MobilePhone,DepotID ,these are in my contacts table ??? Thanks, Nick C

Hi, I have a table with contact details of over five hundred drivers, they all can drive between 1 and 3 different types of vehicle, some can drive all three and some only one, how is the best way to show what vehicles these drivers drive, should I create a SEPARATE TABLE for VehicleID , My...

Hi Brian, Thanks for reply, I know how to create a lookup but because the causes could be so varied a drop down list would be very long !, can I relate the delay to a delay that was inserted previous i.e. 76328 caused delay due to losing wheels ! That is what I mean by duplicating the...

Hi, I am creating a table about recording train delays, there are numerous trains and they could all be delayed or cancelled for the same reason, i.e. Landslide or Lightning Strike etc. Can anyone tell me the best way to record this info without having to type in the same thing numerous times...

Hi, Thanks for reply but I am a little mystified about the response, can you advise of an alternative method of acheiving this please !!! All the Best, Nick C :)

Hi, I have a table with called Transactions and a Table called Equipment, In the Transactions Table I have a field for number of items returned and a field for items taken, if I input 1 into items returned I would like the in stock field to add 1 to the instock field and if I enter 1 into the...

Hi All, I am now going to try and create a database that will keep a check on stock levels in an emergency cupboard we have, I would like to be able to record who takes any stock from the cupboard i.e Name and Pay Number and item taken and whether it was returned or not with dates...

Hi Thanks for reply, Yes thats it, could you explain a little further how to do this ,I am new to all this, I have alot of trains that run almost the same everyday ie 1F10 will run Mon-Fri and depart everyday at 1000 but not run Sat or Sun, I just dont see the need to...

Hi, Thanks for reply, I was wondering if I could say put a DaysRun Field and then insert 1,2,3,4,5 to show it runs 5 days then if it only ran Sat and Sun enter 6,7 in field or would I have to create separate tables for each day run ? Cheers, Nick C

Hi, Does anyone know how I can record something as being used Mon-Fri without having to record the item 5 separate times in a table, i.e. if I created a table 1=Mon,2=Tues,3=Wed etc could I record the item in a table i.e. DaysUsedTable and then put 1,2,3,4,5 etc in the field column once or is...

Hi All, I posted a thread about 2 weeks ago about using dates but am still abit disorientated !. I work for a Train Operating Company in the UK and would like to use a database to store and retrieve information about train arrivals and departures from my station, I understand the tables and...

Hi, Thanks for all your help and detailed responses ,I will make astart and see how it goes,many thanks again. Nick C

Hi Again, Thanks for replies all, I just need to clarify then that I should create a table for all departures and list each one individually for each day of the week it runs ?? Thanks for help, Nick C