RCB

Exactly. I should be more clear in my request. There is no association between meals available and quantity. I would like to display a list of a month's meals and have blank fields adjacent to fill. I envision pressing "enter" and having the "OrderItems" table populate correctly. My instinct is to code (script) this using variables and find requests. However, this approach in Filemaker is rather ugly and cumbersome. I thought there might be a clever way to use relations and portals to achieve the same result. I hope I am being clear. Thanks again for your help.

comment, Thank you for your help. Your solution helps me preserve my table structure. What I would really like is a form that would present all of the meal options for a particular month with associated quantity fields which I could tab through. I can not think of a way (without scripting) to accomplish this. Any ideas I would much appreciate! RCB

Ender, Thank you for your quick response. I've seen your helpful posts all over this forum and am pleased you've taken the time to consider my question. To use your table naming, giving "Menu Item" a month attribute would not be good design for my case. I repeat menu items several times over the year. Now, I give each item an unique ID and use a separate table to couple the MealID to various months. If I gave my "Meal Info" table a month attribute, I would create much duplication. Without this, I believe the rest of your suggested solution will not work. Am I missing something? A little more about my business and my database--we produce meals to-go based off of a menu of 15-20 selections that change monthly. I use my "Meal Info" table to track the various meals we offer (generic). I use "Unit Meal" to track individual meals. Unit Meal also serves as a join table to "Order." (There is a many-to-many relationship between "Meal Info" and "Order.") What I really have is a small manufacturing business. Perhaps I should study sample relational design for a manufacturing process. I just thought I was missing something simple and obvious in trying to use the key "month" to present only the items available for a particular month when entering a new order. RCB

I own a small food business in which we change our menu every month. My database structure is: Customer >-< Order >-< Unit Meal >-< Meal Info -> Meal History (please see attached sample file). My goal: to be able to add a new order and be able to see only the menu items available for a particular month (and input quantities of meals). Thanks in advance for any help! RCB Food_Biz_Sample.fp7.zip