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