CodeCharge Studio
search Register Login  

Visual Web Reporting

Visually create Web Reports in PHP, ASP, .NET, Java, Perl and ColdFusion.
CodeCharge.com

YesSoftware Forums -> Archive -> GotoCode Archive

 CCS : Many-to-One, Grid Display?

Print topic Send  topic

Author Message
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?

   


These are Community Forums for users to exchange information.
If you would like to obtain technical product help please visit http://support.yessoftware.com.

MS Access to Web

Convert MS Access to Web.
Join thousands of Web developers who build Web applications with minimal coding.

CodeCharge.com

Home   |    Search   |    Members   |    Register   |    Login


Powered by UltraApps Forum created with CodeCharge Studio
Copyright 2003-2004 by UltraApps.com  and YesSoftware, Inc.