|
Content with label tables in Documentation for Metrix Developers and Consultants (See content from all spaces)
Related Labels:
custom, consultant, developer, systemadministrator, import, interactions, metrixadministrator, lookup, views, pivot
Adding a Look-up Table for an Existing Custom Table
Adding a Lookup Table for an Existing Custom Table See also: Importing Custom Tables into Metrix Planning Custom Interactions Occasionally, you will realize that a field in an existing custom table needs to be entered using a set of lookup values ...
Other labels:
lookup, custom, consultant, developer
|
Importing Custom Tables into Metrix
TOC: #Import Custom Data Using the Developer Module #Importing Custom Table with No Existing Data #Migrate Custom Data to Interactsql.adp #Setting up Interactions in Metrix Importing Custom Tables into Metrix See also: About Interactions Docs:About ...
Other labels:
import, custom, consultant, developer, systemadministrator
|
Preparing Custom Tables for Importing Interactions
TOC: #Preparing Data Tables #Matching and Updating Temporary ID Fields #Replacing the Temporary ID Codes Preparing Custom Tables for Importing Interactions See also: About Interactions Docs:About Interactions Building Complex Custom Interactions with Existing ...
Other labels:
import, interactions, custom, consultant, developer, systemadministrator
|
Building New Custom Tables for Interactions
TOC: #Database Design Fundamentals #Making Data Atomic #Making Data NonRepeating #Making Data Mutually Independent #Building Custom Tables for Interactions #Custom Interactions Requiring Multiple Fields #Custom Interactions Requiring Multiple Records #Custom Interactions ...
Other labels:
custom, consultant, developer, systemadministrator
|
Planning and Building Custom Tables
Planning and Building Custom Tables Introduction Once you have gathered the requirements and planned the Custom Interactions, you are ready to build the custom tables that will hold the Interaction data. There are two strategies for building custom tables in Metrix: Creating new data ...
Other labels:
custom, consultant, developer, metrixadministrator
|
Including Custom Tables in an Interaction Definition
Including Custom Tables in an Interaction Definition Custom tables are associated with an Interaction through the Interaction Definition. You must be logged in as the Metrix Administrator in order to add Interactions. # Log in to Metrix with Metrix Administrator rights. # Click Customize in the Navigation ...
Other labels:
interactions, custom, consultant, developer, metrixadministrator
|
Adding a Column to an Existing Custom Table_
Adding a Column to an Existing Custom Table See also: Importing Custom Tables into Metrix Planning Custom Interactions Occasionally, you will need to add a new column to a custom table that you have already imported and setup in Metrix. # Open ...
Other labels:
custom, consultant, developer
|
How to create a pivot table view in Metrix when using MS Access 2003
More detail to come, but for now you can follow these steps: # Open Metrix with the <shift> key bypass # Create a query in Metrix as you normally would (or use an existing query) # Open the query to view its data # In the MS Access ...
Other labels:
views, pivot
|
|
|
