Anyone know how to create a multivalue field from lookup wizard and instead of having a checkbox for each item, you can manually input the quantity of each item? Is this possible?
Novice
Windows 7 32bit 
Access 2010 64bit
Anyone know how to create a multivalue field from lookup wizard and instead of having a checkbox for each item, you can manually input the quantity of each item? Is this possible?
VIP
Windows 8 Access 2010 32bit
short answer is no - multivalue fields are not used in this way. Create a separate table and store the required values in there
Novice
Windows 7 32bit Access 2010 64bit
Well dang. Is there a long answer? lol
VIP
Windows 7 64bit Access 2007
Sure! The long answer is no - multivalue fields are not used in this way. Create a separate table and store the required values in there!Originally Posted by wjcox
Linq ;0)>
Novice
Windows 7 32bit Access 2010 64bit
Ok got it. Any advice on how I can setup that table? I am still learning access so it has been somewhat challenging. I am making a non-conforming database for parts that have been scrapped. I have multiple tables either setup, transferred from Excel, etc. I will have to use multivalue fields in several fields on my main table. I have a table that has all of the causes of scrap listed(such as dimensional, finish, scratches, etc.) I used this list in my main table via lookup wizard to create the multivalue field in the main table. I will eventually have to create a form so that when scrap is entered, they will be able to not only enter the cause(s) of scrap but also how many of each on that same scrap tag. Any advice, where to find sample tables of similar structure would be great.
Multivalue Field Advice
Posting Permissions
Reply With Quote