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

 

[Pat Hartman]

@MelissaMuz Welcome aboard

Multi-value fields are not appropriate for your requirement. Experts don't use them for anything. In this case you need a child table and you need to use a subform to manage the table. I've attached a sample database that shows how to work with a many-many relationship.

Many-to-many example

I added a new version on 1/16/23 so choose that one rather than the old one unless you specifically want the old one. The old zip file contains both A97 and AXP versions of the database. It uses venue booking as the example and shows the relationship from both sides. A venue main form with...

www.access-programmers.co.uk

 

[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