I have a db used to store data about orders taken by a home delivery chinese restaurant.
I have a main form displaying customer info and a subform showing details of a customer order. While testing it, I realised that I can only store one dish per customer when in reality a customer may order several dishes and multiples of the same dish. I realise that I can save each customer order one at a time, reselecting the same customer until the order is complete, but this seems inefficient.
What options have I to resolve this issue?