New work to be inputted as per the specified fields below.
All jobs taken from Active when the STATUS drop down is changed from Active to 1 of the choices eg Delivered Collect etc.
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.
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
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
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.
6 freelancers are bidding on average $279 for this job
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.