How to select multiple of an item on a list

[MelissaMuz]

Hi, I'm new to Access and I was wondering if it is possible to select an item multiple times on a drop down list on a table (where multiple items will be selected). Or if this is not possible, I would like to be able to write in the box the quantity of the item needed. Any help would be appreciated!

 

[arnelgp]

you can create Tables (transaction table on the demo)
to save the item and the quantity.

see transactiosn form.

 

[theDBguy]

Hi. Welcome to AWF!

 

[MelissaMuz]

you can create Tables (transaction table on the demo)
to save the item and the quantity.

see transactiosn form.

thats great! I would love to know how to create something like this!

 

[bob fitz]

Hi, I'm new to Access and I was wondering if it is possible to select an item multiple times on a drop down list on a table (where multiple items will be selected). Or if this is not possible, I would like to be able to write in the box the quantity of the item needed. Any help would be appreciated!

Can you tell us something about the db you would like to create

 

[MelissaMuz]

Can you tell us something about the db you would like to create

yes, it's an order tracking database basically! I want to track orders per project

 

[bob fitz]

yes, it's an order tracking database basically! I want to track orders per project

Show us your tables or attach your db to a post here

 

[MelissaMuz]

Appreciate the help! I have restarted my database now lol. It will work much better this way