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, 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

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, 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, 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, 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, I would like to create a table with separate train ID numbers and then create a separate table with days of the week (i.e. Mon,Tues,Wed etc), I would then like to be able to link a train ID with which days of the week it runs on (i.e. Train ID 1H12 runs at 10:00 Mon,Tues,Wed,Thurs,Fri) ...

Hi, I am trying to create a lookup from another table to insert data into a field but when I finish the wizard it says that the fieldsize has been shortened and will some data maybe lost then in the text input box the data changes to number !!!!! Can anyone help,I will attach screenshot ...

Hi All, I am new here so sorry if sound a bit vague. I am trying to create a database with info about Train Drivers and Guards Contact details ie Mobile Numbers and depot etc. I have created a table one with Train Drivers Numbers and one with Guards Numbers, I have made fields for First...

Hi all, I am fairly new to Forum so sorry if I've posted this in wrong place ! I need some help please, I am trying to create a database with all the trains that leave and arrive at my station each day, I would like to insert information about booked arrival times and departure times and...

Hi, Can anyone suggest a good home learning course for a beginner that would contain Database,MySql and PHP. I am going to have an operation soon and my work are going to possibly pay for a course for me to study whilst off sick ! I have completed a Dreamweaver CS3 course and would like to...

Hi, I am trying to get my head round how I can fill out an excel spreadsheet daily with data from a database, can anyone help explain further !, I have designed a spreadsheet with train running info on it in excel. I have created a sheet for Mon,Tues-Thurs,Fri,Sat and Sundays. The reason for...