This is similar to point #1 in this thread: Possible improvements to interface/visualization
However, instead of making them different colors, maybe just highlight the row that is clicked on in both the target table and the relationship the table shares.
- table A - Order_id (PK), Phone, Address, Customer_id
- table B - Order_id, Customer_ID, Product_id
Both table A/B have a reference on order_id and customer_id
Ideally, if I click on table A, order_id; it’ll be easier to just highlight order_id in table A/B rather than order_id and customer_id.