Two Masters, one detail

[McFloyd]

Hi there,

I have a question that it's kind of tricky. First, my scenario is that I
have a master table that contains program names. Then there's this details
table that contains when these programs execute. The detail table contains
the program ID and the schedule ID when the program executes. My datagrid
reacts to a combobox control that contains the program names, and that works
fine. the problem comes when I need this datagrid to show the Schedule Name
instead of the Schedule ID. I have a schedule table where the names are
stored, but one program can have many schedules, so I would need to update
each record in the datagrid with the Schedule name, depending on the Schedule
ID. And I don't know how can I do that without reading record by record and
updating this field in a dynami dataset bound to my Dgrid.

Any thoughts?

Thanks!

[McFloyd]

Well, as nobody here even cared to help me, I had to figure this myself. I
trimmed down the records with a dataview, and then change each record in the
dataview with the corresponding value using a 'foreach' iterator.

If somebody is in the same situation I hope this helps.

Good luck!
"McFloyd" wrote:

Hi there,

I have a question that it's kind of tricky. First, my scenario is that I
have a master table that contains program names. Then there's this details
table that contains when these programs execute. The detail table contains
the program ID and the schedule ID when the program executes. My datagrid
reacts to a combobox control that contains the program names, and that works
fine. the problem comes when I need this datagrid to show the Schedule Name
instead of the Schedule ID. I have a schedule table where the names are
stored, but one program can have many schedules, so I would need to update
each record in the datagrid with the Schedule name, depending on the Schedule
ID. And I don't know how can I do that without reading record by record and
updating this field in a dynami dataset bound to my Dgrid.

Any thoughts?

Thanks!