At some point in the past, maybe in the class I attended of Kevin McNeish's, I could swear that I set up a datagrid and then set up multiple sets of column/format properties for it based on multiple data sources. IOW, once the properties were set (through the builder I now can't find), if I had the grid bound to, say, dsProduct, there were, say, 4 columns, each bound to a column of the dsProduct dataset. If I then bound the grid to dsCustomer, there were, say, 3 columns, each bound to a column of the dsCustomer dataset. Colors could vary as well, based on which dataset was bound.

I know about the property builder and have been using it to customize grids for several pages. NBD. But that does not seem to allow me to specify a different set of properties for multiple datasets. Anyone have an idea what I'm talking about (not me, obviously) and where/how I can get to that feature?

Alternatively (if I was dreaming about that, no one knows what I'm talking about or it's not a good idea to use whatever that was), here's what I'm trying to do. I have a web page that lets someone enter a ZIP Code and a # of miles (x). They then choose whether they want to see a list of either ZIP Codes, Area Codes or Counties that (loosely) fall within x miles of the entered ZIP Code and then submit the query. I already have a COM component that gives me min/max lat/long coord's based on the ZIP/miles they enter, which I can then use to query a database and get the list of ZIP Codes, Area Codes or Counties, in case anyone wondered about that part.

What I wanted to do was set up the one grid that I'm already using to list ZIP Codes so that it would also list Area Codes or Counties, depending on the user's (radiobutton) choice. I know I could write code that would set all of the grid properties when they submit the query and maybe someone will say that's the way I should go (probably). Or, I could drop on 3 datagrids, configure each one for one of the 3 datasets that can be returned, and only make visible the one they select. But I'm curious about whatever that builder was that (I think) I used before to have different sets of properties for the same datagrid and have them set at runtime based on which dataset it was bound to.

TIA and my apologies for rambling (sometimes stuff is hard to 'splain briefly).

Kelly