- Creating a New Table
/pages/Guides/Desktop/Design/Data/DBF/Creating a New Table.xml
Typically, you create new database tables by defining their data field structure in the Table Editor window. Other methods for creating tables include:
- Creating a Table Lookup
/pages/Guides/Desktop/Design/Data/DBF/Creating a Table Lookup.xml
You can use a record in another table as the source of the lookup values. You can also define a lookup that fills in several fields with values from fields you select from the lookup table. For example, you might define a lookup for the Prod_ID field. The lookup finds the matching Prod_ID record in the Product table and fills in the Price field.
- Create a New Table by Example
/pages/Guides/Desktop/Design/Data/DBF/Create a New Table by Example.xml
The Create Table - by Example process infers the table structure from sample data.
- Create a New Table from Sample Data
/pages/Desktop/Reference/Design/Data/DBF/Create a New Table from Sample Data.xml
Alpha Anywhere allows you to create a table by entering sample data.
- Creating a Tabbed Control
/pages/Guides/Desktop/Design/View/Layout Control/Creating a Tabbed Control.xml
Tabbed controls provide a familiar, tabbed interface that you can use on a form to organize fields, controls, and other objects. For example, you have a form in which you enter invoice information. By creating a tabbed control, you can have one tabbed page on which you fill in customer information, one page on which you enter billing information, and a third page on which you enter individual line-items.
- Enter a New Record
/pages/Guides/Desktop/Design/Platform/Xbasic Action Scripting/Records/Enter a New Record.xml
The Enter a New Record action creates and displays a new, empty record for the user.
- Creating a WHERE Clause
/pages/Guides/Desktop/Design/Data/SQL/Creating a WHERE Clause.xml
A WHERE clause filters (limits) the records that you will select with a SQL statement.
- Creating a Custom Component
/pages/Guides/Mobile and Web Components/Custom/Creating a Custom Component.xml
Creating a custom component involves four steps.
- Creating a Posting Field Rule
/pages/Guides/Desktop/Design/Data/FieldRules/Creating a Posting Field Rule.xml
During data entry, you can post values in the current field to matching records in a second table, thus adding to, subtracting from, or replacing the value in a second table.
- Creating a Workspace
/pages/Guides/Desktop/Design/View/Database/Creating a Workspace.xml
In this lesson, you learn about designing a workspace application. You create a new workspace and workspace tables, and learn about defining data fields.