I’m imagining being able to access the data in a linked record in a similar way to how you access child properties of objects in many programming languages.
You have an ORDERS table and a PRODUCTS table. PRODUCTS contains Item Name, Item Code and Price columns. The ORDERS table has a Linked Record field called Products. You could then access the Products properties within a formula field in the ORDERS table like this: