Named Cells as Fields

Named Cells as Fields

The SaveToDB add-in lets you use Excel named cells as fields to get and set values for the active table row.

The naming convention for the cell must be: field_<Excel table name>_<column name>.

For example, if your table is named "Orders," you would name a cell like field_Orders_OrderID.

When a user changes the active row in the Orders table, the add-in will automatically update the corresponding value.

Additionally, you can define a simpler name, such as "OrderID," for the cell. This way, the add-in will reload all queries that include the OrderID parameter.

This approach is a straightforward way to create master-detail forms.

Check out the Wizards, Online Examples, and Sample 08 - Northwind, specifically Sample 08 - Northwind Orders.xlsx.

You can easily create these form fields using the Wizards under Developer Tools by selecting Add Form Fields.

See also:

This website is using cookies. By continuing to browse, you give us your consent to our use of cookies as explained in our Cookie Policy.