not sure how to layout- tables/Forms

[Guest]

Sure there is a lot more for the business - just need this computerized for
now.

Currently doing this all on paper. Here goes.

Presently the top part of the DAILY Sheet lists all available trucks to use
in order of union priority. there are some other columns that go with each
truck

example:

Contacted WK Contacted No WK Truck# Phone# Contact Client ID Location
5 555-1234 joe
12 555-1222 ann
14 555-0101 carol
22 7878787 jim
3 8866 tom
There are approx. 300 trucks

Down below I'll call them Dispatch id come in
Dispatch Id Clientid #Loads Location PO# Comments
1 ABB 5 South st. 2277
2 RW 3 1st St. 378
3 ABB 2 Kelly ave. 257

For that given day all on one sheet as the Dispatch id's come in we
highlight say in green the first dispatch id and then go above and assign 5
trucks-since 5 loads ( highlight in green) write next to them the Client id,
Location - we can assign 5 different trucks on the same truck 5 times on any
variation there of. then onto highlighting in Pink for dispatchid2. and
trucks above accordingly. Don't them to be able to assign the truck once it
is used for that day unless it is used for multiple trips for same
dispatchid.

Not sure how to lay this out. Have a client table and truck table so there
can be drop downs. Just not sure of how to interact the tables and to show
ALL trucks and all dispatch id for a given day.

Thanks,
Barb

 

[Guest]

Any ideas - have been working on a while - getting no where. Bottom line
would like to see all of the records for a given DAY on the Main form(not one
record at a time) and see all TRUCKS - assign - and release as day goes on -
would like to match color code trucks assigned to what given jobs and see
all. New day - List off all trucks from previous day now available and
visible to be assing for new day of jobs(again- see and add jobs for New
day!!) Can have truck assigned, truck released - incase gets done early and
can do another run for that day. Also can assing same truck 5x for a given
job( may need 5 loads=trucks)
Please help,
Barb