Ideas on form design wanted

G'day,

Just looking for some thoughts at this stage.

I am writing a program for a mate who has a small courier company. I need a list of drivers and the jobs (8 columns of data) they have to do. The number of jobs varies between 0 and 15 at any one time. I thought this would be the way to go ..

Driver 1
job 1
job 2
job 3
job 4
Driver 2
job 1
Driver 3
etc

To reduce the amount of 'white space', I'd like the driver headings coloured and the jobs below them with no blank lines. Thus I'd have to add a record or delete a record in the right place.

Would a flexgrid be the simplest way to do it? I could search for driver number and then insert a record if needed, or my mate would click on a job once it has been done and it would be deleted or flagged or moved to a different file.

Thanks.

Peter.

Why not use a flexgrid, and keep each Driver in a different column?
You could even use two colums for each drive, allowing you space to enter the time that the delivery was completed for each job.

G'day,

Thanks David. The problem is that I need a lot of info for each job, including pickup point, drop off point, special instructions and a couple of other things.

However, yoour idea made me think that it might be practical to put limited info in each drivers column and my mate could click on the job and bring up a list box (or something) to display further info about the job. I'll see my mate tomorrow and discuss it with him.

Thanks

Peter.

You could double-click on any job to get the details.

G'day David,

Yes, but I believe that you can't have a click and double click events together on the same item so I'd have to make different arrangements. Not a major problem.

Thanks.

Peter.

Just pop up a textbox when you click on an item. You could have different views. this is just the overal view for drivers. you coud have another for jobs, and another for locations (distance). you want to know that each job gets done by the end of the day, and which jobs are still out. if problems arise, you need to re-classify to get things corrected.

There is already code on the forum (and other places) for a floating textbox. The one I use floats over a cell, and is the same size as the cell, but you could even have a separate form pop up, like a 3x5" card with all the info.