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	`AND` `and` `+` (plus symbol) `&` (ampersand)	`cat AND dog` `"cat food"+milk` `"cat food"&"dog food"`
Either word in a topic	`OR` `or` `\|` (pipe)	`cat OR dog` `cat \| dog`
Topics that do not contain a specific word or phrase	`NOT` `not` `!` (exclamation point)	`NOT cat` `! dog`
Topics that contain one string and do not contain another	`^` (caret)	`cat ^ mouse`
A combination of search types	`( )` parentheses	`cat + (dog \| mouse)` `cat \| dog + (! mouse)`

Service Management2017.11

Develop > Tailoring > Links > Virtual joins > Example: Creating a virtual join > Use the virtual join

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.

Send Help Center feedback