Created attachment 175248 [details]
Base_External_Table_Advanced-Settings

In Base requires a SQLite database with a table in it - see https://wiki.documentfoundation.org/Documentation/HowTo/Base/Connect_to_SQLite

1. run following SQL in Tools → SQL

CREATE TABLE org(
  name TEXT PRIMARY KEY,
  boss TEXT REFERENCES org
) WITHOUT ROWID;
INSERT INTO org VALUES('Alice',NULL);

2. Right-Click a Table, Database, Advanced Settings

==========

1. Help topic is not in same order as Settings Window which makes it harder to use.
2. Note: Help 14 "Ignore currency field information" App description is "Respect the result set type from the database driver"

==========

Help App Description
1    1   Use SQL92 naming constraints
2    3   Use keyword AS before table alias names
3    11  End text lines with CR + LF
4    2   Append the table alias name in SELECT statements
5    4   Use Outer Join syntax '{OJ }'
6    5   Ignore the privileges from the database driver
7    6   Replace named parameters with ?
8    7   Display version columns (when available)
9    8   Use the catalog name in SELECT statements
10   9   Use the schema name in SELECT statements
11   10  Create index with ASC or DESC statement
12   16  Comparison of Boolean values
13   12  Form data input checks for required fields
14   15  Ignore currency field information
15   13  Use ODBC conformant date/time literals
16   14  Supports primary keys