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: