What controls to use?

[Aeric]

I am creating a form for production planning. It has a grid for time in hour for 7 days a week. For each day, the production starts at 7am to 5pm (but sometimes, it may have overtime until 9pm) So, I will make it fix at 7am to 9pm.

I have no idea how i can accomplish the form design. I need to keep track when a production starts, continues and ends. Then when another new production start from where the last production ended.

In mind mind now is to create some square pictureboxes or image controls and let user click and the squares change color which represent the status like Green=start, Yellow=running, Red=stop and White for no production in progress.

I am also thinking of using drag and drop arrow (images) with lines but i don't know how to use drag and drop.

The status or layout of the planning of each production need to save in a database and print as a weekly production planning report using Crystal Reports.

I am not sure what controls to use and how am i going to design the form.
Any gurus can help me?

[jOrgo]

i hope this could resolve your problem.

the file attach here i think can help you in some other way.
You can also use the concept of this program.
Just use Select or If Condition.

[Aeric]

Sorry, I still don't get the idea.

[Al42]

Is this for a small, fixed number of types of productions, or new types of productions all the time?

[Aeric]

I wish to get an idea for a simple production first. I 'll try to figure out for cases of more complicated one.

[Aeric]

My application will be able to print a report like in this attachment.