MultiLevel Item list on Acces Form

[bartus991]

I'm willing to create a concession sales programm in access 2007, but I'm stuck.

The concessions programm will have two different Items
1. Sales Items
2. Menu Items, which contains 2 or more sales items

I have created a kind of switchboard on an Access Form with all the sales and menu items on it. After clicking one of these items the apporiate records will be made. But on this form I would like to have a product list, which show the following:

Quantity Item Price Total
1 Coca Cola 3.00 3.00
2 Fanta 3.00 6.00
1 Duo Menu 8.00 8.00
1 Coca Cola
1 Coca Cola
1 Popcorn Salt.

Above means that the sold Duo Combo exist out of 2 Coca Cola and 1 Popcorn Salt.

I was thinking of creating a table with the sold sales items and a separate table of the menu items with a sub the containing sales items. But it's also possible to create one, with 2 levels, only the menu items will get a sub with the selected sales items.

Creating the tables and the VB code to fill the tables won't be a problem. But creating I can't figure out how to create a Item list as above mentioned, containing 2 levels.

Hopefully you can help me out to create this 2-level item/product list.

The items must also be selectable to delete items. Which means if you click on menu Item all off the following lines will be selected:
1 Duo Menu 8.00 8.00
1 Coca Cola
1 Coca Cola
1 Popcorn Salt.

I am open for ideas, and al ready tried different ways to create the tables, but with none of them I can create a Mutlilevel list. I have thought about a treeview but then I can't add 4 columns (Quantity, Item, Price and Total).

The table structure will be something like:
Order-Id Quantity Item Price

Awaiting you ideas and solutions.

 

[MajP]

First thing is you need to get your tables correct. Since you made no mention of a juntion table for your many to many relationship I can pretty much guarantee your table structure is incorrect. Once your tables are correct then you can worry about forms. When posting table structure post as

tblName
idfieldName (primary Key, data type)
field2Name (data type)
field3Name (data type, foriegn key to x table)
.....

The above view can be accomplished with a list view that allows sub levels, but there may be some simpler ways.