I have a problem that i have no idea how to approach. I have customer tables in two different applications that i want to be able to pull up in a datagridview in the application that i'm developing.
the fields in table1 are CCode, Cname, Caddress, CPhone and fields in table 2 are CCode, Cname, Caddress, CPhone (for our purposes, the same) I want a single datagridview with just the 4 fields from each table combined. In other words, i don't want a total of 8 fields in the datagridview. Is there any way to accomplish this? I'm pulling the data from an SQL Database using VB.Net to develop in. Thanks for any help. Ben
