Trouble setting up table structure

[Crash1hd]

I want to create a form that has 2 drop down boxs when choosing the selected drop downs then I would have 2 other boxes that would indicate say store and price! so in total I have 30 items 40 levels of the 30 items and these 30 items can be sold at 7 different stores for differnt values so the 2 drop downs 1st one would be the item the second its level the 3rd box is a txt box that would say which store to sell item at and the 4th one would be the price that store would buy it at! I am not sure how to approach it

 

[Crash1hd]

I dont need the combos to control each other they are indipendent from each other they need to control the info that shows up in the text box based on table data!

 

[Crash1hd]

My choice is a query.

Problem is that there is 7 tables and in those 7 tables there is 42 Field Names and about 30 records so when I create a query to show all in one it says that there is too many fields! cause there would be a total of 294 fields

 

[Mike375]

Problem is that there is 7 tables and in those 7 tables there is 42 Field Names and about 30 records so when I create a query to show all in one it says that there is too many fields! cause there would be a total of 294 fields

I am having difficulty grasping your situation. However, is it approximately like this:

There is one table for each shop and there are seven shops?

Each table has 42 fields and it sounds as though each of the tables are the same except for the actual details of the entries, that is, the prices for different items vary in each table.

Of the 42 fields in each table how many need to be involved so as to calculate/compare the item/price deal you wish to obtain.

Mike

 

[Crash1hd]

Honestly I was using totally the wrong approach what I was doing was creating a table for each store well I found out there is more then 7 stores and room for exspansion however and there are 40 levels right now but again room for exspansion and the only thing that wont change easly is the items as they are set and there prices! different price for each level of the item and a different price at each store for each level so what I had was a mess now its all clear I made:

1 table that names all the stores
1 table that names all the Items
1 table that names all the levels possible
1 table that puts it all together

so in this table I have a field for store name the level the item name and its price to buy and sell! Now I just have to figure out how to get them to work in the form lol, but I will post that in the proper forum if I have trouble