By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,508 Members | 1,856 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,508 IT Pros & Developers. It's quick & easy.

Two Masters, one detail

P: n/a
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!
Feb 8 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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!

Mar 2 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.