Hi!

Scanning of records of table when order is set in the alias is very slow. Try a simple sample:

Open that table and use COunt command or SUM command to calculate something over all records. Then use SET ORDER TO TAG command and run the same commands again. Do you see difference? When grid displays data, it scans records too. When you calculate values in these textboxes, you probably experience the same problem.

I would recommend to use a view and requery it with child records each time when main record data changed. This way can speed up things, though I'm not sure.

>It seems a little more detail of my situation might help. I have four tables, a resource table with manufacturing days and number of people avaliable for ecch month of the year, a timekeeping table where hours charged against a job number is stored, a main program table where all active programs(by job number) is stored, and finally a table that is used to shcedule hours per week for each job number and resources assigned to each. Now the form I am working on is first based on the main table by job number, the grid is what holds the schedule part or table. I use the data table on the grid to set up the relationship with relationalexpression. Now to explain my other form methods: One textbox tells me how many hours have been charged to the job number, several textboxes give info about how many hours are avaible for the month I want to schedule - how many resources I have - how many hours have been scheduled already - and do I have a deficit or surplus in hours. The form is very active.