Hi, first post on here and relatively new to access with basic vba knowledge form Excel.
I have a problem i am struggling with. Basically I have the following tables:
- Tbl_Brand
- Tbl_Variety
- Tbl_DrinkSize
- Tbl_Product
Using soft drinks as an example I am trying to create a form that allows me to select i.e Coca Cola from the category combobox, diet coke from Variety Combobox and then this is where i come unstuck. Basically i want to be able to select multiple drink sizes for the same Variety. Ie diet coke is available in 330ml, 500ml, 1L, 2L etc. I have these sizes in Tbl_Drinksize.
By doing the above the aim is then when i sell a product via an invoice and choose product it would read "diet coke-500ml" for example. I have read not to use multivalue fields so not really sure how to do this on a form and also then how to populate it back into a table.
Any help will be greatly received.
Cheers
Chris