Blog Viewer

What is a lookup form and why is it important?

Forms are how the user interacts with the LOB application. Without forms, the user will not be able to create, delete, and update table values.

A lookup form is a form from which the user can search for table values. They may also be able to open or delete existing records, create new ones, and export data to Excel.

What do I need to know to begin learning about lookup forms?

You should already be familiar with the following:

• How to use S3
• Creating and editing entities in S3
• Application architecture, specifically the application server: metadata cache, database cache, and business tier
• Creating and editing records in the LOB application
• Database standards
• Writing SQL queries
• Basic C# language

What do I need to know to start working with lookup forms?

You need to understand the following:

• Lookup Form User Functions
• Lookup Form Layout
• Adding Controls to the Form
• Common Lookup Form Buttons

What can I do with a lookup form?

You can perform the following lookup form tasks:

• Create Forms Package
• Add a Form to the Site Map
• Edit the Lookup Form Details and Properties
• Configure the Criteria Panel
• Configure the Search Results Panel
• Add a Sub Query
• Add a Main Query Join and Add Collection Values to the Results Grid
• Add a Cascading Drop Down
• Configure the Advanced Criteria Tab
• Configure Retrieval
• Configure Grid Grouping and Filtering
• Configure Sort Hierarchy
• Configure Deleting Records
• Configure Validate Delete
• Add a Multiselect Drop Down

What do all these words mean?

• Lookup Form Glossary
  
  

What do all these fields and buttons do?

• Universal S3 Controls
• Lookup Form Surface Controls
• Lookup Form Details Controls
• Right Click Menu Controls
• Left Panel (Toolbox Tab) Controls
• Left Panel (Entity Tab) Controls
• Table Properties Controls
• Column Properties Controls
• Break Properties Controls
• Button Group Properties Controls
• Caption Properties Controls
• Cascading Drop Down Properties Controls
• Checkbox Properties Controls
• Checkbox List Properties Controls
• Compare Validator Properties Controls
• DateTime Picker Properties Controls
• Drop Down Properties Controls
• Grid Properties Gridview Controls
• Grid Properties Template Field Controls
• Grid Properties sfwLabel Controls
• Horizontal Rule Properties Controls
• Hyperlink Properties Controls
• Knob Properties Controls
• Literal Properties Controls
• Multiselect Drop Down Properties Controls
• Panel Properties Controls
• Radio Button Properties Controls
• Radio Button List Properties Controls
• Range Validator Properties Controls
• Regular Expression Validator Properties Controls
• Required Field Validator Properties Controls
• Slider Properties Controls
• Switch Checkbox Properties Controls
• TabContainer Properties Controls
• TabSheet Properties Controls
• Textbox Properties Controls
• User Defaults Properties Controls
• Non Lookup Form Controls

What do specific form buttons do?

• Apply Sort Button Properties Controls
• Columns to Export Button Properties Controls
• Create New Record Button Properties Controls
• Delete Selected Records Button Properties Controls
• Execute Server Method From Lookup Button Properties Controls
• Export All To Excel Button Properties Controls
• Export To Excel Button Properties Controls
• Export To PDF Button Properties Controls
• Generate Correspondence Selected Rows Button Properties Controls
• Go Back Button Properties Controls
• New Record For Update Button Properties Controls
• Open Lookup Button Properties Controls
• Open Selected Records Button Properties Controls
• Open Word Document Button Properties Controls
• Reset All Controls Button Properties Controls
• Retrieve Button Properties Controls
• Search Button Properties Controls
• Search Criteria Required Button Properties Controls
• Store User Defaults Button Properties Controls
• View Grid Chart Button Properties Controls

I have more lookup form questions!

• Click here to read form questions from other users.
• Click here to ask a new question about lookup forms.