Ok here goes. I have 3 tables, one holds case info, the 2nd holds possible outcome on the charges, and they're joined on a 3rd table (CaseOutComes). With me so far? Easy stuff, now for the hard part.
Since there's a very common possiblitly that the Case has multiple charges, we need to track those, and therefore, display them on a datagrid or some other control. I want the user to be able to edit the info and have X number of dropdowns pertaining to how many ever charges are on the case. I can get the query to return the rows no sweat, but ...merging them into 1 record (1 row) with mutiple drops is seeming impossible -- I thought about using a placeholder and added the controls that way, but it was not in agreement with what I was trying to tell it
.
Any ideas on how to attack this?
You are saying you have the query working. Are you having problem displaying the data? If so I can move the post to Datagrid section where you have a better chance of receiving help.|||I think its more sql based than grid based -- might be both (probably is). Here's an example.
ndinakar:
Are you having problem displaying the data?
Table - Cases : caseID (pk), CaseNumber, Notes
Table - Outcomes : outcomeID (pk), outcome
Table - CasesOutcome : caseID (fk), outcomeID (fk)
Data - Cases :
caseID : 1
CaseNumber : 2007xx45
Notes : (empty)
Data - Outcomes :
outcomeID : 1
outcome : guilty as charged by judge
outcomeID : 2
outcome : pled guilty to felony assault charge
outcomeID : 3
outcome : pled guilty to felony theft charge
Data - CasesOutcome:
caseID : 1
outcomeID : 2
caseID : 1
outcomeID : 3
When this is all said and done, a grid is generated with two rows, repeating the data (shows the case number twice) which is not really desired -- the outcome however is. Ideally the two of those items would show up under the gridview in 1 column (when being edited, they change to dropdowns) -- but I'm not sure if this is even possible.
|||Can you post the query you have, and the expected result.