>Hi Terry, thanks for answering. We won't have to deliver the contracts foxpro. We currently have a diagram that shows the flow as to where the contracts need to be reviewed.

It seems the information on the flow chart needs to be transcribed or transferred or interfaced [with] to a table based solution. If there is a requirement to have a calendar based pick and approve listings and notices.

Would it be better to look at transferring information from tables to a worlflow chart service, rather than the other way around?

>Also most of these contracts belong to grant so they go thru approval and review process.

It seems the starting point would be receipt of the proposal or bid for the contract.

>There is a timeline that will need to set for these contracts and also email the person reminding them that contracts needs to be reviewed, signed, and moved onto next phase.

Again if the timeline cannot be read from the workflow service, the picks would need to be maintained in a table.

>One of the problems we have is there is no way of tracking the current phase the contract is in. Things get misplaced, contracts are nearing their due dates and commuication breaks down between individuals. I was thinking of creating a program that tracks what phase the contract is in, emailing capabilities (in novell groupwise) reminding individual of deadlines approaching, and if possible create a generic template so the can replicate the flow of contract and the also add more features to contract. Almost all contracts are going to end up in.

Contracts can only move to the next phase if current phase is complete. Somebody will have to punch in the contract - and approve to release to next phase. Again - the timeline would probably need to be maitained in a table, rather than a workflow diagram.

>Microsoft word Document. We will usually scan proposal or draw them up in doc. Visual represent of the contract flow would be a bonus, but not necessary. I would be nice if I can tap in groupwise calandering and notification features though foxpro.

This seems backwards - it seems like the break points in the proposal would be entered into a timeline table - and then your VFP app through something like a Visio or Word automation could generate the workflow diagram as well as provide an engine to notify contractors and contract managers.

>
>thanks
>Nick Patel