I have 2 tables that display orders to be processed. Top one is through Delivery, while the bottom one is through Self-Collection.
I don't want to keep them into 2 separate tables because all of them deal with orders and it's easier to search just one table for a particular order than have to search in 2 different locations.
But then the other columns would be redundant to the other (Self-Collection).
What is the best way to handle this?