I need to create a list and form to enable my colleagues to call customers about their orders, but only when the order status matches certain criteria.
My steps so far:
- I created a simple database with customers and orders. For certain orders statusses we have to call the customer. I created the customer tabel, the status tabel, the call tabel and linked them.
- I created a query which customers have to be called (a query for status A, still need to create one for for status B, C etc.).
- I created a form which displays the customer info, including a subform. The form is based on the Customers tabel.
This is what the form looks like:
It looks perfect, because it displays the customer including all their orders.
My problem:
I don't need a form for every customer, I need a form for every customer that has to be called. Ideally I would create a form based on that query. But then i don't get the form to look the way I want.
How can I create a form in such a way that it displays the way I need it to display?