Named Cells as Fields

Named Cells as Fields

The SaveToDB add-in allows using Excel named cells as fields to get and set the active table row values.

The cell name must follow the following rule: field_<Excel table name>_<column name>

For example, if you have a table like "Orders", you can use a name like "field_Orders_OrderID".

The add-in will update the value when a user changes the active row in the Orders table.

As the add-in allows using named cells as parameters, you can add a name like "OrderID" to the cell.

As a result, the add-in will reload all queries that have the OrderID parameter.

This is a simple way to create master-details forms.

Look at the Wizards, Online Examples, Sample 08 - Northwind, Sample 08 - Northwind Orders.xlsx.

You can easily create such form fields using the Wizards, Developer Tools, Add Form Fields.

See also: