Table functions manipulate sets of records: Filter filters, Sort sorts, Search looks for text, LookUp returns the first matching record, AddColumns adds columns, Sum or CountRows aggregate. They combine to feed galleries and lists.
Example
LookUp(Clients, ID = 12).Nom