I would like to make a document to plan dinners between two roommates. There will be a set of restaurants only ordered from by one of the two roommates, as well as another set of restaurants from which both like to order. There’s a meal plan that only one of the two roommates cooks at home, as well as another set of meal plans on which they work together.
Since restaurants and home cooking plans are distinct types with different attributes (restaurants have phone numbers, URLs for ordering, business hours; meal plans have ingredients, preparation time, etc), I would prefer to keep these in separate tables.
I would like to end up with a table where the rows are Mon, Tue, Wed, Thu, Fri, Sat, and Sun; the columns are person 1 and person 2, and the cells within that table specify the dinner plans from each person, pulling from the correct available dinner options (either ordering from a particular restaurant or cooking at home) for each person. I know how to make all of the individual tables, but I don’t know how to establish a column that lets me reference multiple tables and choose either a restaurant or home cooking option for each cell. Is this possible? Is there another way I should organize this data? Are there any examples that would help me? Thanks