Id like to have a user interface... User enters an order number and clicks a button. Button takes user to the related record in a particular layout? Script?
Yep or least a script step in button setup, but I'd use a script. The key phrase in your post is "related record". See Go To Related Records in FileMaker help.
Retrieving data ...