I've worked with a database system in the past that allows you to setup
permanent joins between two tables in a database such that if you select
record 1 say on a parent table and then add records to a child table, the
child table automatically knows that this record is a sub-record of record
1 in the parent. Thus I can have databases with table structures like:
Customers: Orders: OrderedItems
Without having to always execute complex SQL queries every time.
Can I do anything with MySQL to make it act in the same way?