I have a produce table that records certain values for each of my supplier's produce. Most of this produce supplied is used to populate a vegetable box that is delivered to our customers. (But not all of them... )
Our vegetable box sizes are small, standard and large: in our produce table I have three fields. One is called small, one is called standard, and one is called large. In each I enter the weight amount/quantity amount of the produce I would put in the corresponding boxes: ie 1lb in a small box, 1.5lb in standard box, 2lb in a large box.
Then when a customer places an order, I enter generic details, including the size of Vegetable box they've ordered. I also have further details for their order which is a found set made up of all the produce we are supplied. Here I can enter the quantity amount of each produce ordered: this gives me the opportunity to customise vegetable boxes should our customers dislike a particular vegetable, or they want more of one, compared to another.
The point is, can I get the quantity amount in the more specific details to originally default to a small box size, standard box size, or large, depending on what the customer has ordered, with the ability to change the quanity if needed?
If I haven't explained well enough, please tell me, and I will try to elaborate!