hello every body
as i am new to ms access. but i have designed a form in access 2003
named it as inventory of items.
in this form the fields are item no (this is combo) item name (this is read only) and so on....
one table is working behind this form called item inventory table.
i have one more table called item entry table where the fields are item no item name unit code and unit name,
whenever the user enters the item no in the inventory form or he selects form the combo box list (here the data is displaying from item entry table)
the name also should come in the inventory form field item name.
please give the solution for this how to display the name in my form from item entry table.
million thanks in advance
as i am new to ms access. but i have designed a form in access 2003
named it as inventory of items.
in this form the fields are item no (this is combo) item name (this is read only) and so on....
one table is working behind this form called item inventory table.
i have one more table called item entry table where the fields are item no item name unit code and unit name,
whenever the user enters the item no in the inventory form or he selects form the combo box list (here the data is displaying from item entry table)
the name also should come in the inventory form field item name.
please give the solution for this how to display the name in my form from item entry table.
million thanks in advance
