Hi
iam using vb2008
my backend is sql
my tables have been designed, relations set and sample data enterd
the front end needs to be on vb2008
the connections have been made and the tables are in vb
i have a basic doubt
i have created a datast with 2 tables
table custmer details ......pk is customerid
table workorder................fk is customerid
i have set the relation between these 2 tables
where iam stuck
on the form i have populated the fields
customerid from workorder table is a combobox
when i select a customerid from the combobox, i need all other related
customer details data like address name to be populated automatically
how do i do this
please help
hemanth

Can you post the code you used to retrieve your data and bind it to your combobox?