Hello all
I have a table that links when two pieces of equipment have been tested with
each other:
Equipmentid1 Equipmentid2 Testid
1 3 1
1 4 2
3 5 3
I need to pull this information to be displayed in a table, with the
equipment names displayed across the top and left side (same list for both).
Then the testid to be displayed within the table were the row/columns meet
of the tested equipment.
Problems:
1. How to leave a blank were no test id goes (i.e. equipment 1 was not
tested with equipment 2).
2. Do display testid for both pieces of equipment. The testid for
equipment 1 & 3 should be displayed twice, once in equipment 1's row and
once in equipment 3's row.
Something like this:
Equip1 Equip2 Equip3 Equip4 Equip5
Equip1 1 2
Equip2
Equip3 1 3
Equip4 2
Equip5 3
Right now all the tests ids are being displayed but with no blanks.
and the test for equipment 1 & 3 is only being listed on equipment 1's row.
I'm getting this:
Equip1 Equip2 Equip3 Equip4 Equip5
Equip1 1 2
Equip2
Equip3 3
Equip4
Equip5
Can anyone help
thanks
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Get the mailserver that powers this list at http://www.coolfusion.com
FAQ: http://www.thenetprofits.co.uk/coldfusion/faq
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
