Re: F4.5: Multirecord block and non-database fields

If I understand your need, I suggest using the POST-QUERY trigger to issue a select statement to obtain a related value. This trigger fires as each record is fetched from the base table.

Perhaps a better-performing approach is to create a view which joins the two tables. Then base your block on that view. That way you get your data in one network trip.

Al Received on Mon Mar 03 1997 - 00:00:00 CET