Practical Programs

[Jesse]

I was wondering if the is a method for determining the name of the table that DvTDM is focused on.

We are creating separate tables for projects and sites and connecting Form Design to the new managed tables. These form designs will not have certain fields which are used in our Required fields macros.

Is there a way (Application.ActiveTableName?) to access what table currently has focus when a user is on the form design aside from the form design name?

[Pawel]

There is no built in property for this at this time.

It would involve a number of lookups:

1) get current form design name
FormDesignName = Application.FormDesign
2) get form design's linked
FormDesignMasterTableID =
... SELECT MasterTableID FROM SY_TEMPLATES WHERE TEMPLATENAME = Quoted(FormDesignName)
3) get table name from
FormDesignTableName =
... SELECT TABLENAME FROM SY_TABLENAMES WHERE ID = FormDesignMasterTableID


However, since you are checking for "Mandatory" fields, it would probably be more appropriate to check whether a specific field is in fact on the Record tab, and this again would involve a number of lookups, linking form designs, screen elements, database fields, etc.

Rather than wirtting a "generic" ValidateAllMandatoryFields() macro function, I would suggest writting a function which takes a list of field names, that you know for a fact exist in the relevant form design, are visible on the Record tab, and are editable, and then validate only those fields.