I am building a form for users to update ordering data that has already been entered, for invoicing. There are a number of miscellaneous items that can be added to an order, with associated prices. There is no limit to the number of miscellaneous items that can be attached to an order (equally, there might be none).
I am thinking something along the lines of a drop-down list of all the miscellaneous items, which when selected would then be added to the order, perhaps with an accompanying field for quantity.
I need to be able to add another identical field so that more miscellaneous items can be added, and have the option to delete these fields if necessary.
The contents of these fields would
be appended to that attribute of the order record (e.g. from "coffee" to "coffee, newspaper"). Sorry if I'm not using the correct database terms, I'm very new to this.
Anyway, is this possible? I don't really know what I should be searching for to try to solve this.