José,

>I have some forms based on CBizObjMaintenanceForm that needs to be refreshed in Real-Time. I mean, if there are two users with a "Clients" form open and one user adds a new record, the other user´s form should be updated accordingly. I could automatically refresh the form from time to time, but there are some forms with more than 5.000 records and the refresh can consume some time to complete. Any tips? I´m using 4.1 version and migrating (rewritting) to version 7.

I think, this question is independent from MM. Two things are coming to my mind:

1) You could have a column in that table that has the last change date/time for the edited record in it.

2) You could make a table that contains two columns: table name and last change date/time.

When requerying the view in your form, you could store the current date/time in a property and periodically check this against the value stored in 1) or 2) and only requery if really necessary. IMO 2) is the faster solution, since there are only as many records in it, as you have tables that must be automatically requeried. In option 2) you could use a trigger to automatically store the last change timestamp.

HTH,
Armin