Transport Database
$100-300 USD
Maksettu toimituksen yhteydessä
Database requirements:
Tables
Active List
New work to be inputted as per the specified fields below.
Completed List
All jobs taken from Active when the STATUS drop down is changed from Active to 1 of the choices eg Delivered Collect etc.
Reports
Invoice Supplier
Generated by supplier name with date choice eg from and to certain dates. This is from Completed Table
This report need to show following columns:
Date Received, Date Completed, Name, Postcode, Description, Charge.
Run Sheets
To be created from Active list showing the following columns
Date, Name, Postcode, ADD1, ADD2, Tel No, Mob No, Instructions, ADV and signature box .
This report is to be derived by selecting a Driver name, then sorted by the priority field and then by the Postcode but the printed sheet does need to have a signature box.
Also can you auto save these run sheets into a specific folder.
Required Fields in Both tables
Field Name Supplier Date Rec Order No Cust Ref Postcode Name ADD 1 ADD 2 Tel No
What type of field Drop Down Auto date
Options selection on on input
inputted data
Field Name Mob No Desc Instructions ADV Charge Status Driver Priority
What type of field Drop Down Drop Down Drop Down
Options Yes Active selection on
NAns Delivered inputted data
Ncon Collected
Eng Cancelled
AP
There is an existing database which can be modified or the whole thing can be written from scratch.
I have attached a word copy of the above.
Projektin tunnus: #17804
Tietoa projektista
6 freelanceria on tarjonnut keskimäärin $279 tähän työhön
InfogateSoftware is the only ISO 9001 certified company listed here. We are in the field since 1998. We had done 200+ projects in past 6 months. You may choose us priorly over freelancers.
Hi, i will be able to build your database for you according to your requirements. Please refer to pmb for my details Thanks. Regards.