This is all done in Microsoft Access 2007 and SQL Server. We are creating a way for our users to quickly make notes on a customer. These quick-notes will contain tags that will prompt the user for data based on that tag. The tags are to be limited to a few select options for the user to pick from. The tags will be coded as [TAG] in the database.
A couple examples:
[[OrderNumber]] - Was refunded
When the user selects the above example, he/she would be prompted with a list of the currently selected customer's orders and a field to allow the user to input a specific order. When the user chooses the order, the quick note would look like:
 - Was refunded
Emailed receipt for order [[OrderNumber]] to email address: [emailAddress]
Would look like:
Emailed receipt for order  to email address: Seymour@butts.com
The main issue is that each tag invokes a different action.
- An order number tag calls up a function that will extract the order number from a few columns in an order table.
- An email address tag will show all the current customer's email addresses or allow the user to put a different email into a field.
Our Purposed Solution
We though about putting the data into a table with the following format:
╔════════╦══════════════╦══════════════════════╦════════════════╗ ║ NoteID ║ NoteTag ║ columnReference ║ tableReference ║ ╠════════╬══════════════╬══════════════════════╬════════════════╣ ║ 1 ║ emailaddress ║ email address ║ emailAddTable ║ ╚════════╩══════════════╩══════════════════════╩════════════════╝
Now this table may be a quick way to grab the data, but it will be awkward for function calling, and a lot will still be handled programmatically.
What is a clean and simple way to invoke particular calls to action in a program based on the tags in a quick note? A big loop checking for tags in a string and then calling the specific functions?