T
Th1
Im currently working on a school project and having trouble with the subform part. It involves making a sales order
The tables involved are: $=primaryke
tblcustomer: $cust#, custname, address, city, etc..
tblsalesorder: $so#, sodate, cust#*, emp#
tblemployee: $empl#, employeename, emplyee job descriptio
tblinventory: $inv#,name, description, pric
tblsaleorder-inventory: $so#, $inv#, soquantit
My form currently is like thi
So# [__________________
sodate[______________
Employee#(combobox emplyee#/employee name)[_________________
Customer#(combobox cust#, cust name) [_______________]---| (choosing a cust# autofills name and adress
customer name[_____________________] <
customer adress[___________________] <
------------------------------------------------------------------------------------------------------------------------------
subform has a datasheet forma
[Inventory#(combobox)][ invname][invprice][soquantity][extension:soquantiy*price
Ok here is my question for the subform im trying to make the inv# autofill the inv name, price like how in the main form cusomter# autofills custname and custaddress and im having trouble accomplishing this task.
Any advice on how to do this will be welcomed. thank you
The tables involved are: $=primaryke
tblcustomer: $cust#, custname, address, city, etc..
tblsalesorder: $so#, sodate, cust#*, emp#
tblemployee: $empl#, employeename, emplyee job descriptio
tblinventory: $inv#,name, description, pric
tblsaleorder-inventory: $so#, $inv#, soquantit
My form currently is like thi
So# [__________________
sodate[______________
Employee#(combobox emplyee#/employee name)[_________________
Customer#(combobox cust#, cust name) [_______________]---| (choosing a cust# autofills name and adress
customer name[_____________________] <
customer adress[___________________] <
------------------------------------------------------------------------------------------------------------------------------
subform has a datasheet forma
[Inventory#(combobox)][ invname][invprice][soquantity][extension:soquantiy*price
Ok here is my question for the subform im trying to make the inv# autofill the inv name, price like how in the main form cusomter# autofills custname and custaddress and im having trouble accomplishing this task.
Any advice on how to do this will be welcomed. thank you