In Access 2000 I have created a DB that calculates the price of a computer depending on the items you choose. Each componet has it's own table-form where you can enter characteristics like it's name, price etc. There is a Computer table-form where you choose the product you want via a combo box(I don't know how it's called in English-it's the one that you click on it and the products appear until you choose,and then it returns to it's original state-like the one Internet Explorer has to enter the address) for each category. The combo box displays the names of the products via a query in each of the categories table, and shows the name cell. (case,cpu, hsf,m/b,hd etc). It also has a text box for the price next to each category. The question is how can I show the product price as the user selects a product. I mean how can I show it in the nearby text box? Does it have anything to do with relations and stuff like that? Please help!!!
Thanks. Any help would be appreciated.
Thanks. Any help would be appreciated.
Facebook
Twitter