Searching the Help
To search for information in the Help, type a word or phrase in the Search box. When you enter a group of words, OR is inferred. You can use Boolean operators to refine your search.
Results returned are case insensitive. However, results ranking takes case into account and assigns higher scores to case matches. Therefore, a search for "cats" followed by a search for "Cats" would return the same number of Help topics, but the order in which the topics are listed would be different.
Search for | Example | Results |
---|---|---|
A single word | cat
|
Topics that contain the word "cat". You will also find its grammatical variations, such as "cats". |
A phrase. You can specify that the search results contain a specific phrase. |
"cat food" (quotation marks) |
Topics that contain the literal phrase "cat food" and all its grammatical variations. Without the quotation marks, the query is equivalent to specifying an OR operator, which finds topics with one of the individual words instead of the phrase. |
Search for | Operator | Example |
---|---|---|
Two or more words in the same topic |
|
|
Either word in a topic |
|
|
Topics that do not contain a specific word or phrase |
|
|
Topics that contain one string and do not contain another | ^ (caret) |
cat ^ mouse
|
A combination of search types | ( ) parentheses |
|
Use the virtual join
Applies to User roles: System Administrator
Once you save the record, you see the virtual join information whenever you select, add, or update the record.
To create a new orders record using the orders form.
- Click Tailoring > Database Manager.
-
Type orders in the Form field, and then click Search.
The "orders" form opens.
- Type the name of a customer in the Customer Name field.
- Type a contact for that customer in the Contact field.
- Type a number for the Phone field.
- Type any number for the Order Amount value.
- In the Seller Code field, select a seller code from the record list of seller codes.
- Click Add to save the new orders record.
The new orders record appears with the sales file data virtually joined in the subform at the bottom.
The Seller name and commission fields are not stored with the record in the order file. They are only referenced and are noneditable. To make changes or updates to the seller data, use the sales form.
Note: If you delete this record, Seller name and commission do not delete because they are stored in the sales file.
Related concepts
Virtual joins
Understanding subforms
Example: Creating a virtual join
Build the sales form
Create the sales file
Create the sales record list
Add data to the sales file
Create the sales1 subform
Create the orders form
Build the virtual join into the form
Build the link
Verify that the sales1 form works