First, the table structure - design in Visual FoxPro usually starts with the table structure!

You say that you want the same value for several months. If some of those values can change, you may want to have separate records, one for each month.

Another option is the following: If the value doesn't change frequently, have a table where you only include months where the value changes.

Month       Value
Jan. 2004   1000
Jan. 2005   1200
Jul. 2005   1300

This can be less work for the user, to edit the values. The user should understand the following. In the example, since there is no value between Jan. 2004 and Jan. 2005, the value "1000" applies to the entire period from Jan. 2004 to Dec. 2004 (starting Jan. 2005, a different value applies).

Then, you need a lookup function that, if you give it a month, will return the value. The setting SET NEAR ON can help you here.

For the end-user to change the values, yes, you can use a grid. Personally, I don't like editing directly in a grid. I use the model provided by Visual Extend (get the sample application, to see what I mean): The grid is used for finding a record. The editing of the record itself is done in TextBoxes, etc., outside the grid (below the grid, or on a separate Page in a PageFrame).

Greetings,

Hilmar.

>hello,
>
>thank you for evry thing.
>
>i want to ask somthing else,
>
>
>i want to compute (number like 450.600 .or 8000 or 65200...etc)
>this number distriputed for 13 months equally. ex..
>if i have a number as 850.600 and begin at 14/03/2004 to /03/2005
>form 14/03/2004 to 30/03/2004 the value is 40.1672
>every month after that form month 4/2004 to 2/2005 every month take the same value as 70.8833
>month3/2005 take a value 30.7161.
>****************************************************
>my code, do that for one year only, as 13 month
>my qustion is how i can do that if they want to comput this total value for (ex.. 2month s or 3, and more one year maybe one and half or 2year maybe more,
>remark: i useto put 13 textbox at my form to do that ,thats mean how i can do that if 2 years or more.
>is there any new idea to do that,maybe if use a grid.
>
>regards.