Please enable JavaScript to view this site.

R:BASE 11 Help

Navigation: How To (Forms, Reports, and more) > Queries/Views > Query Builder > Using the Query Builder

Query Builder Settings

Scroll Prev Top Next More

The Query Builder provides settings to alter the method of linking tables for your queries. To access the query builder settings, select "Query" > "Query Builder Settings" from the main menu bar.

 

QBE_Settings

 

 

Select "Common Column Names" to link tables by common columns.

Select "PK/FK" to link tables by columns that have constraints.

Select "None" if you do not want R:BASE to automatically link tables.

 

Continuation Characters - adds plus characters (+) to the SQL syntax panel to easily recycle the code