View forms

View forms enable AR System to point to and access data in relational database tables outside AR System. The table can be located on the same database instance or in any other database accessible from the current AR System database.

Because view forms access data outside of AR System, the developer must understand the database data types and have access to the external database table containing the data. 

Related topics

Creating-vendor-forms

SQL-database-access

icon_play.pnghttps://youtu.be/-bgEvWTjhHY

The following table lists the actions you need to perform to create and use the view forms:

Action

Reference

Create and modify view forms

Check the AR System database-supported data types

Check the AR System database-requirements

Verify the field properties on view forms

Set up a remote database for view forms

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*