Important alert: (current site time 5/19/2013 1:38:05 PM EDT)
 

'Ask the Visual Basic Pros Discussion Forum


You are in: Discussion Home | ADO 2.0_And_2.5  | Table relationships in access and vb6
 
Table relationships in access and vb6 
 
Author:  pfazen (75.86.254.12) on 5/21/2010 1:51:11 AM
 
Message: 
 
I recently tried to set up a program in vb 6 and am finding I am a bit rusty. I have an access database that has a relationship between Products and Inventory transactions based on PRODID. I used VB form builder wizard to create a form with ADO connection to the db, and whenever the form loads, it puts the PRODID NUMBER into the inventory transaction datagrid rather than the text NAME of the product. The Product table is the Parent and the Inventory Transaction table is supposedly the child and the relationship is bound on the ProductID

Please email me at pfazen@gmail.com if you can help!!

I know it is something stoopid simple but it has been years since I have opened VB 6

Patrick 
 




To reply, please login using the link on the upper left hand corner of the screen.