allowing users to expose more rows?
I'm kinda new to this so thanks for any help!
I have a database with a field for "items" that a customer wants to purchase. Sometimes there are 5 items sometimes there are 35 items.
How can I set it up so that the "items" field can be expanded by the salesperson to as many or as few items as they need. right now my database is set up with a static number of items and if the customer wants to order more, then the salesperson has to create another order to handle the additional items.
Can this be done and what is the "best practice" for this thanks.