471,321 Members | 1,810 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,321 software developers and data experts.

Two Masters, one detail

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
1 1090
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.

Similar topics

reply views Thread by Brian | last post: by
reply views Thread by luffmusse | last post: by
2 posts views Thread by mike | last post: by
reply views Thread by arturklis2 | last post: by
1 post views Thread by daveh551 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.