Hello,
I need your help guys.
I have a Database ( MS Access 2000 ) in which there's 3 Tables(E1_Customer, E2_Supplier and E3_Product). Two Attributes in E1_Customer table are the foreign keys of Table E2_Supplier (Supplier_ID) and E3_Product (Product_ID).
In my VB Form, ( called Modify_Information.vb ), it needs to read all the data from E1_Customer table. I have been able to bind some of the data to read from Table E1_Customer but the rest of the textboxes are blank and these are the foreign keys (Supplier_ID and Product_ID).
Can anybody help me what should i put in my codes to have the data of the foreign keys appear in my form during the modification stage? I am using the runtime coding system instead of the Server Explorer.
If anything unclear, please let me know.
Many thanks.
Salim
I need your help guys.
I have a Database ( MS Access 2000 ) in which there's 3 Tables(E1_Customer, E2_Supplier and E3_Product). Two Attributes in E1_Customer table are the foreign keys of Table E2_Supplier (Supplier_ID) and E3_Product (Product_ID).
In my VB Form, ( called Modify_Information.vb ), it needs to read all the data from E1_Customer table. I have been able to bind some of the data to read from Table E1_Customer but the rest of the textboxes are blank and these are the foreign keys (Supplier_ID and Product_ID).
Can anybody help me what should i put in my codes to have the data of the foreign keys appear in my form during the modification stage? I am using the runtime coding system instead of the Server Explorer.
If anything unclear, please let me know.
Many thanks.
Salim
