View Article

What is a lookup form and why is it important?

Forms represent individual interfaces that enable your users to view, create, update, and delete database table values.

A lookup form is a form from which users can search for table values. Other common user actions include creating new records, or opening or deleting existing records.

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

You should already be familiar with the following:

• Creating and editing entities in Xelence
• Previewing forms
• Writing SQL queries

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

• Lookup Form Tabs
• Lookup Form Design Layout
• Control Menu
• Toolbox Controls

What can I do with a lookup form?

You can perform the following lookup form tasks:

• Create a Lookup Form
• Configure the Lookup Form's Details
• Configure the Criteria Section
• Configure the Advanced Criteria Tab
• Configure the Search Results Section
• Add a Sub Query
• Add a Main Query Join and Add Collection Values to the Results Data Table
• Make a Control Visible Based on the User's Device
• Add a Cascading Drop Down
• Add a MultiSelect Drop Down
• Configure Retrieval
• Configure Data Table Grouping and Filtering
• Configure Sort Hierarchy
• Configure Deleting Records
• Configure Opening the Child Maintenance Form from the Lookup Form
• Make Search Criteria Phonetic
• Configure an Export Button
• Configure a Sub Form
• Create a Lookup Form with the Item Wizard
• Require a Unique Value to Create a New Record

What do all these words mean?

• Lookup Form Glossary

What do all these fields and buttons do?

• Lookup Form Configuration 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.

#Forms