mrc logo mrc logo
  • m-Power m-Power
    What is m-Power?
    Overview Demos Build Process Case Studies Specs Pricing Trial
    m-Power Resources
    Overview How-To Videos Webinars & Podcasts White Papers Fact Sheets
  • Solutions Solutions
    What does m-Power build?
    Overview Database Front-Ends Reporting CRM Systems Business Intelligence Dashboards Inventory Management Mobile Apps ERP Enhancements Modernization Spreadsheets to the web MS Access to the web B2B/Web Portals Scheduling Embedded Analytics Web Forms Workflow Data Exploration Budgeting & Forecasting APIs and Web Services Db2 Web Query Alternative
    Solutions by Industry
    Overview Manufacturing Government Foodservice Software Vendors Logistics & Supply Chain Software Consultants Healthcare
  • Services Services
    Development Services Training Mentoring
  • About About
    Overview Partners Press Releases Careers Events Contact Blog
  • Support Support
    Support Home FAQ Documentation Customer Portal Enhancements Updates Roadmap Techblog
Try m-Power

m-Power Manual

Browse:

  • Home
  • Build Process
  • Data Selection
Back to Manual

Table/Field Selection

After first creating your table, you will automatically be brought to the Data Selection specification screen. Initially, you will be prompted to select your first table. Notice that all of the tables available to you are all the tables that you have registered to your current data dictionary.

table_selection_final

Here you can filter your registered tables, view more of your tables with the next button, preview data with the magnifying glass icon, or select a table using the green plus sign.

After doing so, you will be brought to the Field Selection page.

field_selection_final

Select fields by clicking on the green plus sign.  If you plan on joining out to any secondary tables, it is important that you select fields in the current table that will also be found in the secondary tables.  Once you have selected all desired fields, click accept.

Note:  If you add a field inadvertently, you can remove it by clicking on the "Delete Fields" button.

After clicking accept, you will be brought to the "Data Selection" screen.  So far, you have only selected one table.  Therefore, only this table should appear on this screen.

selected_tables3

From the Selected Tables screen you have three options:

1.  Select additional fields from the table already selected:

Click on the green plus sign under Select Fields.  This will return you to the Field Selection screen. Select your fields, click "Accept".  This will return you to the Selected Tables screen.

2.  Navigate to the application menu:

To navigate to the application menu, click on the application name in the toolbar.

3.  Join to a different table:

If you want to join to a different table, click on Join Table.  You will be brought to the Select a Table to Join screen.

join_table

Click on the plus sign to join out to the desired table.  This will bring you to the Choose Join Table screen.

join_field

All of the fields that are found in both the primary table and the secondary table are shown in this screen.  Select the fields you wish to join over, and click accept.  This brings you to the Field Selection screen.  However, you now see the fields that are available to be selected from the secondary table rather than the primary table.  Select your fields, and click accept.

Now that you have selected the fields for your application, you are ready to move onto the last required specification, Sequencing.  To navigate to the Sequencing screen, you can either return to the application menu (by clicking the application name in the toolbar), or by clicking on the downward facing triangle in the far right of the toolbar, and then selecting Sequencing.

Created: July 5, 2013 | Modified: December 3, 2013

Search


Browse By Category

Build Process (13)
Starting with m-Power (8)
Retrievals (10)
Reports (15)
Summaries (4)
Maintainers (17)
Graphs (8)
m-Power Data Explorer (4)
General (24)
Calculations (5)
Utilities (9)
m-Power Administration (23)
Security (11)
Freemarker (6)
m-Painter (29)
Form Validation (5)
External Objects & UDFs (12)
Deprecated Documentation (23)
Bootstrap Templates (7)

Popular Tags

Production Graphing Video Maintainers Administration Bar Graphs Email Tomcat Calculations Prompt Screens External Objects Bootstrap Templates Form Validation Record Selections m-Painter Admin Compiling Dates RPG Maintainer SQL Parameters mrc-Productivity Series Excel Security Performance Getting Started Data Dictionary Summaries Popular Freemarker Retrievals Reports App Properties Graph Properties Advanced Graphs DB2 Database Build Process Java Report Dropdowns Retrieval Application Properties

See all tags »

michaels, ross & cole, ltd. (mrc)

Privacy Policy Cookie Policy Cookie Settings Notice at Collection Do Not Sell or Share My Personal Information

mrc (US)

2001 Midwest Road
Suite 310
Oak Brook, IL 60523
630-916-0662

mrc (UK)

Mortlake Business Centre
20 Mortlake High Street
London, SW14 8JN
+44-20-335-59566


© 2024 mrc. All rights reserved.