Grab That Data!

By Jennifer Neighbors, Senior Consultant

Ever need a piece of information you stored in another table? It’s fast and easy to grab it if you
remember a simple phrase: “select [table where data is stored].[data field]”. Once you
memorize this phrase, you’ll use it over and over because it comes in so handy. Say you want to
insert a company telephone number onto a form like an invoice or payment receipt. Don’t
“hard code” it. Store it once in a table of company information (“Utilities”). When you want to
place it on your form, use the following formula:

     select Utilities.Phone

Now when your company changes its primary telephone number, they can enter the new
number in their Utilities table and their forms will automatically be updated!