Macro to position form on specific record

Scriptcase 9 Suggestions
#1

Normalized database tables lead to the followin situation:

  • table “family” and table children use the same key “family_id”. Both tables are used in connection with table housing.
    If I need to edit the family and the children record of a large building, housing will allow me to select the proper key to family and children. But how to position to the wanted record?

  • I know, using ajax to press the goto button of the respective application will do the trick. However if the ordering is not strictly ascending or has deleted keys, this method will not work!

Therefore it woul be very helpful to have a macro that can position to the wanted record in Event->onLoad.

#2

Sometimes one cannot see the most obvious: Select the wanted record in SQL settings->sql select statement add a where clause