w2u
|
Posted: 12/17/2003, 12:26 AM |
|
hi all ...
i need to display a many-to-one relation in a grid, whats the best way to go about this?
the data is stored as follows
table one: itemId, part1, part2,part3
table two: statusId, statusName
where part1,2 and 3 store various statusId's.
sample values are:
table1
1,1,2,3
2,2,1,2
3,1,1,1
table2
1,avl
2,navl
3,nreq
and i need to display them as:
itemId : part1 : part2 : part3
1 : avl : navl : nreq
2 : navl : avl : navl
3 : avl : avl : avl
i could manage to do the above using listboxes to show the value of avl, navl and nreq, but its quite an eyesore of a display
any insights?
tia :)
|
|
|
w2u
|
Posted: 12/18/2003, 9:10 PM |
|
cant this be done
i got lucky and managed a temporary solution where i included the second table (status) as many times as required and implemented it as a one-to-one relationship. but i doubt this is good practice ... isn't there a better way?
|
|
|
|