Thank you for your post.
Assuming you have two tables linked together through "AGENCY NO", reference the AGENCY NAME from the related table; not the current table. That way, when you type "1" in "AGENCY NO", FileMaker will look at the linked value in the other table and display the AGENCY NAME.
In a layout, the "Body" displays information for every record. If you don't want to show every record, then remove the Body from the layout and just display the Grand Summary. In Layout Mode, you can move fields and objects around to meet your needs.