Kathie1101
Technical User
Hi
Im hoping somebody can help me. I am new at using Access (using Access 2000) and I am setting up a database but I am having a problem with a form which shows the materials and cost to produce a product. The form consists of the following fields: Card Code, Card Name, Card Type, Card Occassion, then 10 fields named Materials 1-10, with 10 fields for the Unit Price of each material. I also have fields named: cost to produce, selling price & profit. I have used combo boxes so that I can select the materials used from a drop down list, but I need the form to automatically insert the unit price for the corrosponding material used. I have no idea how to do this - help please!
The way I have my database set up so far is:
A table (named stock) showing the materials, stock, unit price before discount, and discount.
I then have a query (named stock details extended) which calculates the unit price after discount.
I then produced my form (named Cards Made) based on the information in the above query.
So, basically I need to know how when a material is selected in my form, do I get it so it enters in the next field the corrosponding unit price for that material.
I hope somebody can understand what I am asking, and I apologise if I have given too much/too little information. I would really appreciate a response if possible that explains it simply, as like I say I am new to using Access.
TIA
Kathie
Im hoping somebody can help me. I am new at using Access (using Access 2000) and I am setting up a database but I am having a problem with a form which shows the materials and cost to produce a product. The form consists of the following fields: Card Code, Card Name, Card Type, Card Occassion, then 10 fields named Materials 1-10, with 10 fields for the Unit Price of each material. I also have fields named: cost to produce, selling price & profit. I have used combo boxes so that I can select the materials used from a drop down list, but I need the form to automatically insert the unit price for the corrosponding material used. I have no idea how to do this - help please!
The way I have my database set up so far is:
A table (named stock) showing the materials, stock, unit price before discount, and discount.
I then have a query (named stock details extended) which calculates the unit price after discount.
I then produced my form (named Cards Made) based on the information in the above query.
So, basically I need to know how when a material is selected in my form, do I get it so it enters in the next field the corrosponding unit price for that material.
I hope somebody can understand what I am asking, and I apologise if I have given too much/too little information. I would really appreciate a response if possible that explains it simply, as like I say I am new to using Access.
TIA
Kathie