I'm adding some validation checks before I make records to my database and I need to fulfil the following condition: Find fieldinfo where fieldinfo.fieldno = 5052 Find codetable where codetable.tableno = fieldinfo.tableno and codetable.code = tt-employee.costcode tt-employee is a temp table , the rest are directly from the db Since I am new to progress I'm a bit confused - should use a join for that and if so any idea how to do it? Thank you! Continue reading...