I have created a database in Access that has several tables related to Patient Information Tables (Patient_Information, Patient_Primary_Insurance, ect) The primary key is PtID in all related tables. I have forms set up in vb that allow viewing information and adding/appending and delete. I have another form that gathers all information together for billing insurance comapanies. My problem is I have a combobox that is bound to DataSet111 wich hold Patient_Information and shows PatientLastName I would like for the combobox to combine FirstName, MidInitial, and LastName from Patient_Information table and further Once a name is selected Infromation is filled in the form such as address (which is broken down as PateintSteet, PatientCity, etc...) and Primary Insurance information from another tabe (Patient_Primary_Insurance). I guess at the most basic I need to figure-out how to pull information from related databases and save the information into variables that I can then combine as I need into textboxes etc...
Thanks in Advance,