Hello,
i am very new to ms access ,but i have created a form for inventory of items,in this form i have many field like item number and item name, unit code unit name and so on.
my question is if i enter the item number in this form it should display the item name from some other table and if i enter the uit code it tshould display the unit name from some other table called unit table (where data is already present).please help me in this regards.
millon thanks in advance.
Configuration: Windows Vista Internet Explorer 7.0