ONE_PER_TABLE

When used within a query the function produces a recordset that contains one record for each parent record defined by the relationship between the tables. When used within a virtual field the function will return True for records that match the criteria given and False for those records that do not.

ONE_PER_TABLE ( <table_name or expression>, <table_name> )

• table name or expression: Can be either a table name, or an expression (a query string or another query domain function) resulting in a recordset.

• table_name: The name of the table at the one end of the one-to-many relationship