
Originally Posted by
ketbdnetbp
There are many different ways you can display such data. Much depends on who, what, where, when, why, and how? In order to narrow down your choices, a few questions need to be answered.
What is the size of the combined data fields you wish to display? Do you just want to concatenating fields from the query and just display a single string, line by line, in a field? How are your tables set up? List tables, fields, and relationships.
What would you like to have happen when orders exceed 12? What do you want to have happen when the opposite is true?
Who or what will trigger the requery, person taking the order (event), auto when new record added, etc.?
What happens when an order is completed before a new order is added? Further, how is a displayed order marked as completed and thus, not displayed any longer?
Who will be using the system, i.e. Manager/Supervisor or Line/Department Employees? One person or many?
Item modifiers (3rd Table?), or are they part of the original query?
As a veteran restaurant person, I admire your ambition.
Let me know the details and I'll try to help you the best I can.
All the best.