Learn more

Formula Tables command

Use this command (Data tab, or in classic view, Database menu) to create, edit, and test the individual formula tables in the standard database. A window opens so you can set up the conditional criteria for returning the correct value to a formula. Formula Tables is available only when a standard database is open.

Tips:

Edit Formula Table is available on a button or on the shortcut menu when you are working with formula tables in other windows.
Use the Options command if you want the Formula Table window to remain in add mode after you save each new record.