If you don't see an opportunity to determine static relations between model tables, you can use an additional WHERE condition in model properties.

    For example, if you don’t wish to join tables in a query, having only to check correspondence between strings of tables, you’ll require a sub query, using the EXISTS construction. If you don’t want to join the “GOODS” table in a query, but have to select goods from the “GOODS” list only, the additional WHERE condition will look like:

and Exists(Select * From GOODS b Where d.GOODS=b.CODE)

where    d                - alias of INVOICE_ITEMS
            d.GOODS     - a field in INVOICE_ITEMS with a goods codes;
            b.CODE       - a key field in GOODS table

www.dataodyssey.com         Table of contents