This question is locked. New answers and comments are not allowed.
Hi
How to make this db design work for master-detail?
Order table (master table)
OrderID ItemID
1 1
2 1
Item Table(detail table)
ItemID Name
1 Apple
2 Orange
The telerik grid wont load the first record's detail, but will display the second correctly like this:
OrderID
1
NULL
2
1 Apple
Everything works fine if I change the itemID to 2 of orderID #2.
OrderID ItemID
1 1
2 2 <<<<--EDIT
Correct report
OrderID
1
1 Apple
2
2 Orange
Hope someone can help me.
You may also check the attached file, for the real table design that im using
Thanks
How to make this db design work for master-detail?
Order table (master table)
OrderID ItemID
1 1
2 1
Item Table(detail table)
ItemID Name
1 Apple
2 Orange
The telerik grid wont load the first record's detail, but will display the second correctly like this:
OrderID
1
NULL
2
1 Apple
Everything works fine if I change the itemID to 2 of orderID #2.
OrderID ItemID
1 1
2 2 <<<<--EDIT
Correct report
OrderID
1
1 Apple
2
2 Orange
Hope someone can help me.
You may also check the attached file, for the real table design that im using
Thanks