hello guys,
I have done stock program in Microsoft access. I created a table with name Items. That table contains itemNo (the primary key). , itemDesc. , unit , and price attributes. Also I created a table with name Sales which contains sales's invoice No (sInvoiceNo) (the primary key), date, itemNo, quantity and total price attributes. Then I created a form which contains sInvoiceNo, date, itemNo, quantity, total price form Sales table and itemDescription, unit, price from the Item table. So when I enter the itemNo in that form , the related information such as (itemDesc, unit, price ) appears automatically (without user) but by this way it is more difficult for the user to remember all of the items Numbers. I tried to enter the itemDesc instead of itemNo but here the related information such as (itemNo, unit and price) don't appear automatically, it needs to fill by users.
Now , my question is I want the related information appears automatically when I enter the iemDesc instead of itemNo
can you help me please and i would be so thankful for you
I'm looking forward to hearing from you,
thanks with regards,