Hi,

I am back making mods to a long serving VFP application for a client after having been involved in mainly .Net development for the last few years and finding that my vfp skills are a little rusty.

I am looking for advice/suggestions on how to visually display data for the following situation:

An order can have between 0 and n actions associated with it.
Each action has a due date, a description and a logical field to indicate whether it has been completed.

Our order enquiry screen has 3 grids linked by relations. The main grid displays Orders, the 2nd grid displays Order Lines for the current Order and the 3rd grid displays Invoice lines for the the current Order.

We would like to display in a column in the Orders grid a graphical representation of the status of the Actions for the order. What we are after is a series of boxes, 1 for each action, coloured according to whether it is complete and/or overdue.

I have been able to approximate what I am after on the body of the form by manipulating a 4th grid that has only the header row visible in the AfterRowColChange event of the orders grid. I then set the number of columns according to the number of actions, resize the columns to fit all the columns within the grid width and set the header back color according to the action status. I set the header tooltip text to the action description. VFP9 sp2 has a bug displaying header tooltips so I have had to kludge a workaround to get the tooltips to display. This works Ok but could look better.

The attached image shows sort of what we are after.

The real issue is that we want the user to be able to see the Action status of multiple orders at a time rather than for the current selected order so the display needs to be in a column of the orders grid.

Any thoughts most gratefully received,

TIA

Andy