Question about relationships

Quick basis design to do exactly what you're asking for using relationships.  https://helpv2.quickbase.com/hc/en-us/sections/4572559184788-Creating-and-modifying-table-to-table-relationships

You should make a relationship where one customer has many order sheets. that relationship to add look up fields to bring down any of the Customer fields, including customer name down to the order sheets table. Be sure to go to the field probably called related customer on the order sheets Table and edit the field properties and choose Customer name as the proxy for that field. Then the field that you want to show on your order sheets, form will be Customer name. will allow you to choose a Customer on the order sheets table or conversely if you launch often customer record to add an order sheet, it will auto populate. 

then, you can make a report of order sheets and put that report on the Customer form and set an additional filter on the configuration panel for that report element to use the order sheets report link field that was created automatically by Quickbase when you made that relationship. That will ensure that when you were looking at a customer, you only see orders relevant to that customer.