Help with microsoft acces forms

[TestUser0]

Let's say I have a list 3 tables:



1) Customer table called tblCustomer - table with all customers each with unique CustomerID
2) A food look up table called lkpFood - table with all the different foods and their category as well as a unique FoodID.
3) A junction table called juntblCustomerFood - a table with relationships to CustomerID and FoodID and then also the number of items of that food item that were ordered.


Now I am creating a Customer form and I want to figure out whats the most user-friendly way to display the foods and allow user to fill the form. Ideally the foods would be separated by category and all the user would have to do is to tick a check box of the food and then enter how much of that item was used. Can I get some help on the best way to do this (ideally with using little to no VBA code).

[Welshgasman]

I would have thought VBA would be needed.

I might have a combo for category. A multi select listbox that depends on that combo.

Then a button to create records in a continuous form that holds a control for the amount of each item.

I use a FAYT combo to find foods, regardless of category in my Diabetes DB. However that is just a simple continous subform.

[TestUser0]

Let's say I have a list 3 tables:

1) Customer table called tblCustomer - table with all customers each with unique CustomerID
2) A food look up table called lkpFood - table with all the different foods and their category as well as a unique FoodID.
3) A junction table called juntblCustomerFood - a table with relationships to CustomerID and FoodID and then also the number of items of that food item that were ordered.


Now I am creating a Customer form and I want to figure out whats the most user-friendly way to display the foods and allow user to fill the form. Ideally the foods would be separated by category and all the user would have to do is to tick a check box of the food and then enter how much of that item was used. Can I get some help on the best way to do this (ideally with using little to no VBA code).

I have tried that but the user said he prefers to have all the foods visible so that he can just tick the relevant ones and choose the qty.

[CJ_London]

I have tried that but the user said he prefers to have all the foods visible so that he can just tick the relevant ones and choose the qty.

why tick a box? just enter a quantity?

and how many foods are there ? Less than can be displayed in one column on the screen? More? If more is the user happy to scroll?

do the foods need to be grouped in some way? Viewed alphabetically? By expiration date?

[jojowhite]

maybe frmOrders on the attached db can be of help to you.

Attachment 53203