Hi all..

I have made a database in Mcrosoft Access 2007. In my Database there are four tables. ORDER, ORDER DETAILS, CUSTOMER & ITEM.

I have made order and order details combine form from Form Wizards. When flling the form of any order when i give the Item_id in the order details, the database automatically dont insert the price of that item_id from the ITEM table in which its price is saved. E.G. like in shopping center while the sales man is making bill, he just insert item_id and the software automatically place the price in the item_price attribute.

please help me. How to make it possible? ill be very thankful. i am new in Microsoft Access 2007

Kindest regards,


I have added 3 items in the item table. Now all the attributes in the table contains values. Whats the next step dear?