I cannot for the life of me figure this out, and I hope someone can help. I have to bind data that comes from several DIFFERNT tables to an asp.net Grid. (kind of an aggregate view)
A customer (custID) can have multiple cars(via FK) each customervehicle(via FK to vehicle table) has several FK relationships to other tables used to describe that vehicle. I need to display data out of the CustomerVehicle ->Vehicle->VehicleType tables.
Anyone give a pointer on how to do that?