How to automatically save a relationship of a select?

I have a database as shown below. When I select a table, I want it to save the order table and I use it in order_details without having to select the order table again.