Displaying values from the correct table

There are several fields that exist in more than one table, and display different data depending on the table they exist in. To ensure that the field displays the correct values, you need to specify the table to retrieve data from on the data service. Click the Output tab in a data service and specify a table in the File column.

For example, you created a data service that retrieves detailed data about a customer using (CRS610MI/GetBasicData), and connect the data service to a form component. Among other fields, the form component contains a status dropdown field. Upon clicking the status field to see the list of values, this field contains values that are not included in the status field in the program 'Customer. Open' (CRS610). The data service also displays status descriptions that are not accurate for a customer record, such as 00-'User-defined', 05-'Template item', and 10-'Item-number, cost'.

Since the STAT field exists in several tables, you need to specify which table to retrieve the status from to display the correct values. Then, return to your data service and click on the output tab of the transaction. On the STAT output field , enter OCUSMA in the File column. Then, save the application. The status field on the form now lists values such as 05-'Preliminary', 12-'Incorrect values', and 20-'Definite', which correspond to correct status values in (CRS610).