hvt@tnosel.UUCP (henq) (02/03/88)
In SQL like systems one can select records from a file based on the values of a field in a connected file. For example, something like: SELECT {all records} FROM {the file} PARTS WHERE PARTS.SupplierID = SUPPLIER.ID {this links the files} AND SUPPLIER.City='New York' {this selects the records I want} Note that no looping nor explicit IF THEN ELSE statements are used. Is something similar possible in 4th Dimension ? How do you do it ? any help would be much appreciated ! -Henk Have a nice day!