adding with lookup fields

[Eolfird]

i have several tables for different computer parts processors, motherboards etc, because there are several different types of each. I then have an order form with the fields processors, motherboards etc all setup as lookup columns. The price of the part is included, in the lookup column, and is what gets entered into the field. what i want to do is select, lets say, a motherboard for £35 and then a processor for £60 and have the total at the bottom but it doesnt work. I think it counts the number of columns in each lookup field instead. any ideas?

 

[Mile-O]

Why would you need so many tables?

You should only need this for all the different items.

tblProducts
ProductID
Product
ProductTypeID
Price

tblProductTypes
ProductTypeID
ProductType

tblOrders
OrderID
DateOfOrder
CustomerID

tblOrdersToProducts
OrderID
ProductID

 

[Eolfird]

There is about 19 different types of product and about 150 products each with there unique model number. I had though of doing what you said but, i thought that i would run into problems when trying to select a product no use going through 150 products. So, how ideally i would like a lookup field with product type after that is selected the remaining fields would need to show only the information related to it. How can i do that?

 

[aleb]

I am not sure but try this ...
Unzip file, open dbase, in "edit WA" you can select WA and add/edit equipment or positions. Then in the main form if you select the certain WA only equipment/position pertaining to the respected WA will be shown.

Regards Alexei