> No, Charlie, > I didn't mean the headers. I know how to rename them. > > What I meant is: > In my DataSource table I have a field "ProducerID". > That points to another table "Producers" with the key field "id" and the > field "Name". Now I would like to have the Column "Producers.Name" in the > list instead of "ProducerID". I mean the field values of the records, not > the headers. >
In Gambas 3, the Table property of a DataSource can be any SQL request. In Gambas 2, I'm afraid there is no simple solution. But try this: use your own DataView control, and create an Observer on the GridView of the DataView control - you get it with the DataView.GridView property. Then catch the Data event with the Observer: by using the Row property, you will know if you are in the ProducerID column, and then you can replace the displayed data with the name of the producer by setting the GridView.Data.Text property. Regards, -- Benoît ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user